Switch Workbbooks

  • Thread starter Thread starter SeanEvans
  • Start date Start date
S

SeanEvans

I am trying to get vba to switch between three workbooks that show a
three different instances on the Windows Taskbar. I would normally us
Workbooks("test.xls").select but this throws up a subscript error a
the workbook in question is not in the same excel instant. Can anyon
point me in the right direction
 
Try using code to create the other instances of excel and
declare them -----Apexcel...Apexcel1...Apexcel2 then use
the Apexcel.application.activate line to swith to the
appropriate instance.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Form 3
Checking for open workbooks Repeat/Loop VBA code 1
Select range from unopened workbook 7
Wilcard for Workbooks??? 1
Switch to Excel workbook in a separate instance of Excel 3
Worksheet names in VBA 3
toggling between 2 workbooks 1
Copy from one workbook to another failing 8

Back
Top