Prompt user for file to be opened

[brentm]

Greetings all,

I am trying to code a macro through VB to open up a specific folder, then
allow the user to specify which file to open. The folder structure is as
follows:
S:\accounting\FINRPTG\MON-END\Interest Exp
From here, there are folders by year that contain the actuals files. What I
would like is for the macro to open up the folder "Interest Expense" and let
the user navigate to and open the specific year folder, and then open the
necessary file, which I will call Interest Exp Template, for this example. I
can get the code to browse to the Interest Exp folder, but from here, I
cannot allow the user to open another folder to get to the actual file. Any
ideas?

Thanks,
Brent

 

[Harald Staff]

Hi Brent

See if this get you somewhere:
http://www.contextures.com/xlfaqMac.html#SelectFile

HTH. Best wishes Harald