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?
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?
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
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().
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks