Thread: Saving workbook from VB
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
  
Posts: 983
Default Saving workbook from VB
All of these are possible solutions... Depends exactly what you want...

ThisWorkbook.Save
ThisWorkbook.SaveAs "C:\Test.xls"
ThisWorkbook.SaveCopyAs "C:\test.xls"
Application.Dialogs(xlDialogSaveAs).Show "C:\Test.xls"
Application.Dialogs(xlDialogSaveCopyAs).Show "C:\Test.xls"

HTH

Thisworkbook.

"Old Car" wrote:

How can I effectively do a "save" or "save as" of a workbood from VB. I
assume there are methods that support this. Thanks.



Reply With QuoteReply With Quote