How to specify path when using SaveAs ?
 

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

How to specify path when using SaveAs ?
 

What happens if you pass in the full path ?

Tim

"Jack" <replyto@it wrote in message
...
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

How to specify path when using SaveAs ?
 

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)



On Sat, 4 Oct 2008 02:07:01 -0400, "Jack" <replyto@it wrote:

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