setting current directory

[jerm.hannley]

Hi,
I want to set the current directory of a file dialog window to where
the existing excel spreadsheet that is running the macro is.

It works fine on my local hd but when i try placing the file on a
network drive it sets it to MyDocuments. This is bad... could someone
direct me to a possible solution?

regards,
jerm

myCurrentFolder = ActiveWorkbook.Path
ChDir myCurrentFolder

 

[John Nurick]

Hi Jerm,

This newsgroup is for questions about using external data with Microsoft
Access. Your question seems to be about programming Excel: you're more
liely to get a useful answer if you post to an Excel programming
newsgroup.