| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening files
I have tried to use the GetOpenFilename application in VBA so that I would be
able to get the Open dialog box to display at a specified place but it will only display the open dialog box of the last file opened is there a application or another method of getting the Open file dialog box to display at a specific place or not? Thank you Heath |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Opening files
Use the ChDir statement (and perhaps ChDrive as well if you need a different
drive) to switch to the directory you want before you execute the GetOpenFileName line. On Mon, 11 Oct 2004 15:41:10 -0700, "Heath" wrote: I have tried to use the GetOpenFilename application in VBA so that I would be able to get the Open dialog box to display at a specified place but it will only display the open dialog box of the last file opened is there a application or another method of getting the Open file dialog box to display at a specific place or not? Thank you Heath |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening files | New Users to Excel | |||
| show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
| Opening files | Excel Discussion (Misc queries) | |||
| Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 | Excel Discussion (Misc queries) | |||
| How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
Linear Mode
