How to specify path when using SaveAs ?

[Jack]

moExcelWS.SaveAs() takes a filename as a parameter and the file is saved in
My Documents folder.
I woul like to specify the folder where to save the file.
How to do it?
Thanks,
Jack

 

[Tim Williams]

What happens if you pass in the full path ?

Tim

 

[Chip Pearson]

Just include the full path in the filename. E.g.,

moExcelWS.SaveAs "C:\Whatever\Folder\You\Like\TheFile.xls"

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)