export location

[Gary Keramidas]

does anyone know if there is a reg key for the default export location of
modules?

i want to change it from the \microsoft office\office11 folder.

 

[NickHK]

Gary,
It would seems that XL2K honours the value of Application.DefaultFilePath,
but XLXP does not and defaults to Application.Path.
So I assume versions after 10 would be the same.

NickHK

 

[Gary Keramidas]

ok, thanks. i just always save mine in the client's folder on the server and
every time i exit excel, i have to navigate to the folder.