How to specify path when using SaveAs ?

J

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
 
C

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