File-> Save As -> How Do I Change Default Location?

  • Thread starter Thread starter Kenji
  • Start date Start date
K

Kenji

I learned that we can change the "save" default path by changing
application.defaultpath

How do I change the default path of "Save As" command? It always points to
where the file is located first. I'm running the excel sheet from a server,
so I would like it to point to the user's local folder. Thanks!

Kenjiro Yagi
 
ChDrive "D"
ChDir "D:\myFolder"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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

Similar Threads

How do I write the column number as number? 1
default file location 4
Cannot get previous data after ctrl + w 0
Access How to change default file save location in Access 2007 5
Changing default "Save As" folder 3
Make changes in the outlook file save as type using C# 0
Changing Default Print Quantity 2
Excel FIXED IT: EXCEL WONT LAUNCH WHEN I DOUBLE CLICK ON THE FILE - INSTEAD HAVE TO USE FILE-OPEN IN EXCEL 1

Back
Top