Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Saving workbook from VB
How can I effectively do a "save" or "save as" of a workbood from VB. I
assume there are methods that support this. Thanks. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Saving workbook from VB
Hi,
Do you mean, VBA? Visual Basic is NOT the same as Visual Basic for Applications. VB < VBA. If you are talking the programming language in which Excel has and is able to utilize, you're talking VBA. VB is a stand alone program which is a little more versatile than VBA. A google search will yield many results. But if you are asking about VBA, then try the following ... Sub testingSave() Thisworkbook.Save End sub or.. Sub testingSaveAs() Thisworkbook.SaveAs "C:\MyWorkbook.xls" End sub Is this what you're talking about? -- Regards, Zack Barresse, aka firefytr "Old Car" wrote in message news:uEwce.90$r81.40@trnddc02... How can I effectively do a "save" or "save as" of a workbood from VB. I assume there are methods that support this. Thanks. |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Saving workbook from VB
Assuming you mean VBA, Save and SaveAs are detailed in help.
-- HTH RP (remove nothere from the email address if mailing direct) "Old Car" wrote in message news:uEwce.90$r81.40@trnddc02... How can I effectively do a "save" or "save as" of a workbood from VB. I assume there are methods that support this. Thanks. |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Saving workbook from VB
Application.Dialogs(xlDialogSaveCopyAs).Show "C:\Test.xls"
gives me a run-time error. Run-time error '1004': Application-defined or object-defined error. Does you know why? Thanks. "Jim Thomlinson" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook | Excel Discussion (Misc queries) | |||
Saving Workbook | Excel Discussion (Misc queries) | |||
saving workbook | Excel Worksheet Functions | |||
Saving Workbook | Excel Programming | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming |