Saving workbook from VB

[Old Car]

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

[zackb]

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" <nospam@nospam.com> 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.
>
>

[Jim Thomlinson]

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.
>
>
>

[Bob Phillips]

Assuming you mean VBA, Save and SaveAs are detailed in help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Old Car" <nospam@nospam.com> 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.
>
>

[Old Car]

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" <JimThomlinson@discussions.microsoft.com> wrote in message
news:C35BDD71-BBF4-43A0-B905-7E84C5819C4E@microsoft.com...
> 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.
> >
> >
> >