| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SaveAs using Hyperlink/Path in a cell | Excel Programming | |||
| Changing Path for SaveAs Functions | Excel Programming | |||
| Macro path follows the "SaveAs" file | Excel Programming | |||
| SaveAs File Path Method | Excel Programming | |||
| SaveAs and relative path | Excel Programming | |||
Linear Mode
