| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
specify an input directory with GetOpenFilename
Give this a shot
'Load the Input Dir InputDirectory = "C:\" 'Save the current Dir for later Clean up CurrentDirectory = CurDir 'Change the Dir to look in ChDir (InputDirectory) 'Load FileNameToOpen FileNameToOpen = Application.GetOpenFilename 'Clean up ChDir (CurrentDirectory) HTH -Merk |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
specify an input directory with GetOpenFilename
Dear experts,
I am using in a macro the GetOpenFilename method to open workbooks on which I am then working. Is there a way I can specify in which directory I want it to open (like a sort of "default value" for input boxes)? Many thanks, Valeria |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
specify an input directory with GetOpenFilename
It works wonderfully!
Thanks a lot! Valeria -----Original Message----- Give this a shot 'Load the Input Dir InputDirectory = "C:\" 'Save the current Dir for later Clean up CurrentDirectory = CurDir 'Change the Dir to look in ChDir (InputDirectory) 'Load FileNameToOpen FileNameToOpen = Application.GetOpenFilename 'Clean up ChDir (CurrentDirectory) HTH -Merk . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation of input against the active directory | Excel Worksheet Functions | |||
| GetOpenFilename w/default starting directory | Excel Programming | |||
| GetOpenFilename | Excel Programming | |||
| Setting default directory prior to GetOpenFilename | Excel Programming | |||
| Using GetOpenFilename | Excel Programming | |||
Linear Mode
