CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2001
    Posts
    4

    Still need help....

    I don't have autosave, and I can't install it because I no longer have the disk. Anyway, so is there a way to save the excel document using the vb editor? And how do I know that whenever the excel document opens that the vb code will even be activated. Do I have to program that into the code as well?


  2. #2
    Join Date
    May 2000
    Location
    New York, NY, USA
    Posts
    2,878

    Re: Still need help....

    Using Vb code you can save Ecell as

    xlapp.activeworksheet.SaveAs "C:\Whatever"

    of course you have to set xlapp object and the other juzz

    Iouri Boutchkine
    [email protected]
    Iouri Boutchkine
    [email protected]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured