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

--
SeanEvan
-----------------------------------------------------------------------
SeanEvans's Profile: http://www.excelforum.com/member.php...fo&userid=1465
View this thread: http://www.excelforum.com/showthread.php?threadid=27563

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.


-----Original Message-----

I am trying to get vba to switch between three workbooks
that show as
three different instances on the Windows Taskbar. I would
normally use
Workbooks("test.xls").select but this throws up a
subscript error as
the workbook in question is not in the same excel
instant. Can anyone
point me in the right direction ?


--
SeanEvans
----------------------------------------------------------
--------------
SeanEvans's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14650
View this thread:
http://www.excelforum.com/showthread...hreadid=275635

.