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

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
 
B

Bob Phillips

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