Excel 2010 Instances

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
klneel
Newbie
Posts: 4
Joined: Tue Jul 21, 2015 5:01 pm

Excel 2010 Instances

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.

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts