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?

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?