Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Export Multiple Macros (Excel 2000)

    Hello~

    Is there a way to export multiple macros at once from the VBA editor or do I have to do it one at a time?

    Thank you!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Export Multiple Macros (Excel 2000)

    You can export a module (with all the procedures and functions it contains) to a text file by right-clicking the module in the Project Explorer, or by pressing Ctrl+E. There is no Organizer as in Word, so AFAIK there is no easy way to export multiple modules at once. It is possible to write VBA code to do that, though, witness Rob Bovey's VBA Code Cleaner (the code in this add-in is not protected)

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Export Multiple Macros (Excel 2000)

    Yeah ~ I guess I should have said multiple Modules instead of Macros...

    It occurred to me that what I really am doing is backing up my modules. Is there an easier way to do it than to export them?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Export Multiple Macros (Excel 2000)

    The easiest way, of course, is to create a backup copy of the entire workbook.

    Check out Jan Karel Pieterse's AutoSafeVBE utility. You can download it from his website http://www.jkp-ads.com (look for Free Utilities)

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    San Clemente, California, USA
    Posts
    130
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Export Multiple Macros (Excel 2000)

    [img]/forums/images/smilies/smile.gif[/img]

    All of my macros are stored in my personal workbook so if I made a copy of my personal workbook then I would be saving all my Macros!

    I have a big smile on my face right now and I am sure I am red, because when I read you email I did a big Homer Simpson- Doh!

Posting Permissions

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