+ Reply to Thread
Results 1 to 2 of 2

Thread: VBA - How to "bring" the macro saved in other file?

  1. #1
    Registered User
    Join Date
    04-27-2009
    Location
    Brazil
    MS-Off Ver
    Excel 2003
    Posts
    13

    VBA - How to "bring" the macro saved in other file?

    1. I build a macro on an excel file worksheet and saved the file.
    2. While using the file, I "save as" the file with other name.
    3. When trying to edit and save the macro on the new file, the name on the tool bar was adding a reference that I dont understand:
    Microsoft Visual Basic - FILE NAME - [MOLDULE4(CODE)]

    I don't know why this "MODULE 4", but I imagine that it is causing a delay when I'm running the macro now...

    Does anybody know how to save the macro on the new file, withou anylink to other sheets??

    Tks!

  2. #2
    Forum Contributor
    Join Date
    10-16-2008
    Location
    Iowa
    Posts
    120

    Re: VBA - How to "bring" the macro saved in other file?

    In VB, right click the module and select Export, then in new file in VB, right click and select Import. This has to be done in VB, not the main Excel window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0