Excel 2010 Instances

klneel · Post by **klneel** » Wed Jul 22, 2015 8:21 pm

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.