setting current directory

  • Thread starter Thread starter jerm.hannley
  • Start date Start date
J

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
 
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.
 
Back
Top