Putting VBA code to prompt to open a file

[HH_Captain]

Hi Friends,

This is Captain H from Saudi Arabia, I am a newbie in VBA excel and was seeking to get a solution as to what code can get the system to ask me what file to open in the external link in VBA excel. Please if someone can help me, would really appreciate it.

 

[Misca]

Welcome to the board!

Try something like:

Dim FileName As String
Dim WB As Workbook

FileName = Application.GetOpenFilename

Set WB = Workbooks.Open(FileName)