Default File Path
Dim sPath as String
' store the current path in a variable
sPath = Curdir
' code to change path
chdrive sPath
chdir sPath
--
Regards,
Tom Ogilvy
"Simon Shaw" wrote in message
...
How do I reset the default file path?
My macro saves a text file out to a network path. But after the macro is
run, when i go to open another file, the default path is the network path
were the macro saved the file. How to I set the default path back to the
path prior to running my macro?
|