GetOpenFileName help

[bhofsetz]

Is there a way to designate the starting directory for GetOpenFileName ?
The online VBA help only says you can designate a File Filter.

TIA

[Leith Ross]

Hello Bhofsetz,

Use the VBA command ChDir to set the default directory. Specifiy the disk and path you want as a string.

Example:
The current directory setting is C:\My Documents

This will change the default directory for Windows to...
ChDir("D:\My Files\Excel Programs")

Hope this answers your question,
Leith Ross

[bhofsetz]

Thank Leith that was exactly what I was looking for.

I added an
On Error Resume Next
line just before the ChDir command line that ends up taking you to the last directory used if the directory specified in ChDir is not avalialbe (i.e. a network drive that is no longer valid).
Does anyone know if I may be setting myself up for trouble by using the
On Error Resume Next
in this way?

Thanks again