I really like using the "Application.GetOpenFilename " method to allow users to navigate to files, but there are times when I would like to help out the users and have the browser start in a specific location. Is there a way, using Application.GetOpenFilename or something else, to open a browser window to a specified path? like C:\MonthyReports\SouthernTerritory\Current Month\Invoices?


Thanks

Not 100% sure on this without a bit more digging but the class I use has a procedure Private Sub OFN_to_WOFN(wofn As W32_OPENFILENAME).

In this procedure there is with wofn....
.nFilterIndex = FilterIndex

the FilterIndex is listed as a variable:
Public FilterIndex As Long
' Initial directory for the dialog to open in.
' Default = Current working directory.

There maybe a way to play with this to get the desired default directory.

At work so really cant play here but that might be a place to start looking.