Set path for msoFileOpen

[JFK]

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?

 

[Ron de Bruin]

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