Open file dialogue box

T

Tinsu

Hello

I'm am looking to do some sort of scenario management system. Basically a form pops up asking the user if they want to create a new scenario or open an existing scenario. A new scenerio is simply a template (excel) file being opened and saved, with the filename being whatever the scenario represents. All the scenario files are saved in one directory. C:\scenarios\
OK this I can do
But when it comes to opening existing scenarios I am stuck, I basically want the user to press the 'open existing scenario' button and get the open file dialogue box showing all the files in the above directory for them to choose from. Can anyone direct me on how to get this box and get it to point to the right directory

Many Thanks
 
R

Robin Hammond

ChDir "C:\Scenarios\"
Application.Dialogs(xlDialogOpen).Show

Robin Hammond
www.enhanceddatasystems.com

Tinsu said:
Hello,

I'm am looking to do some sort of scenario management system. Basically a
form pops up asking the user if they want to create a new scenario or open
an existing scenario. A new scenerio is simply a template (excel) file being
opened and saved, with the filename being whatever the scenario represents.
All the scenario files are saved in one directory. C:\scenarios\.
OK this I can do.
But when it comes to opening existing scenarios I am stuck, I basically
want the user to press the 'open existing scenario' button and get the open
file dialogue box showing all the files in the above directory for them to
choose from. Can anyone direct me on how to get this box and get it to point
to the right directory?
 
Top