View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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