Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a folder
I am trying to find if VBA has a utility that makes it possible to set the
Open File Dialog to a specific folder. For example, if I use this code Application.GetOpenFilename("Text Files (*.txt), *.txt") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a folder
Hi Ayo,
See if the following example helps. However I have not tested it with your specific requirement. Sub Return_Set_Path() 'Return the current default file path MsgBox Application.DefaultFilePath 'Set the default file path 'Note:The following resets the default file path 'to save/open all Excel files as if it has been set in options. strpath = Application.DefaultFilePath & "\Test" Application.DefaultFilePath = strpath MsgBox Application.DefaultFilePath End Sub Regards, OssieMac "Ayo" wrote: I am trying to find if VBA has a utility that makes it possible to set the Open File Dialog to a specific folder. For example, if I use this code Application.GetOpenFilename("Text Files (*.txt), *.txt") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User selection of folder and open all .xls files within folder | Excel Programming | |||
VBA - open folder | Excel Discussion (Misc queries) | |||
Help: Can open a spreadsheet in a folder which contains spaces in the folder name! | Excel Programming | |||
open file from folder save in new folder | Excel Programming | |||
Open files in folder - skip if already open | Excel Programming |