setting current directory

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top