Excel 2010 Instances

[klneel]

Hello All,

I am trying to open 3 different workbooks with macro scheduler, and two of them feed into the other one. In order for Excel to update the links, they all have to be in the same instance. Is there a way to open all 3 workbooks in the same instance?

Code: Select all

Let>filename=Z:\Daily Sales by Rep Report1.xlsm
IfFileExists>filename
   //Start Excel and open the book
   XLOpen>filename,1,xlH

Else
  MessageModal>Could not find: %filename%
Endif

That is the basic code I have, just repeated for the 3 different workbooks.

[Marcus Tettmar]

Hi,

No, I'm afraid not using this method. You could use VBScript and CreateObject to do it though.