View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SeanEvans[_3_] SeanEvans[_3_] is offline
external usenet poster
 
Posts: 1
Default Switch Workbbooks


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