Excel VBA Code Question

[Theresa]

Hello:

I have a macro that opens a specified file. I want the
macro to open any file that I specify in a popup box.

Does anyone have any idea how I can do this?

Thanks.

 

[Dick Kusleika]

Theresa

You can use

Application.GetOpenFilename

that will provide you with the standard File - Open dialog through which you
can change folders and search for files. The GetOpenFilename method returns
a string that is the file name. You still have to open that workbook via
code.