Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro: Prompt user for xls file to add chart | Excel Programming | |||
Prompt user to save their file | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming |