+ Reply to Thread
Results 1 to 3 of 3

Run doesn't work in reference workbook

  1. #1
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Run doesn't work in reference workbook

    When I open a workbook (wb1) that references an unopened workbook (wb2), wb2 opens before wb1!Open() runs. While wb2 is opening "Run(Macro)" doesn't work. It never finds "Macro".

    Is this a bug in Excel, or just a bug on my computer?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Run doesn't work in reference workbook

    You could save wb1 beforehand with the option to not update automatic links.

    I don't understand the rest of your question.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Run doesn't work in reference workbook

    shg;

    You misunderstood. There are no external links. In VBE, you can add a reference to another file (Tools - References), then all the macros in the referenced file are available to the 1st file.

    The reference is what causes the referenced file to open before the 1st file runs it's own Open(). But "Run(Macro)" doesn't work in the referenced file while it's opening. It works fine after the 1st file has run it's own Open().

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.6.0 RC 1