View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
zackb[_2_] zackb[_2_] is offline
external usenet poster
 
Posts: 14
Default 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.