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
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