ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Default File Path (https://www.excelbanter.com/excel-programming/303542-re-default-file-path.html)

Tom Ogilvy

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?




All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com