Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set path for msoFileOpen
I have a VBA application that begins by loading the File Open dialog using
the Application.FileDialog(msoFilaDialogOpen).show command. The application always requires the use to begin in a specific folder on a network drive, so the user must always navigate to the drive before selecting a subfolder, and eventually the files to open. I would like to set the default path to the specific folder on the network drive. Can I do this, and if so how? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set path for msoFileOpen
Hi JFK
I always use this See this example "Merge a range from every workbook you select (below each other)" On this page http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JFK" wrote in message ... I have a VBA application that begins by loading the File Open dialog using the Application.FileDialog(msoFilaDialogOpen).show command. The application always requires the use to begin in a specific folder on a network drive, so the user must always navigate to the drive before selecting a subfolder, and eventually the files to open. I would like to set the default path to the specific folder on the network drive. Can I do this, and if so how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute path | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
New Workbook Path | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions |