GetOpenFileName help
 

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=361261