View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
georgio georgio is offline
external usenet poster
 
Posts: 1
Default Check for open workbook


howdy all
this should be relatively simple, i'm just not sure how to do it

i have 2 workbooks A.xls and B.xls

when i open A.xls, i want it to check and see if B.xls is open
if B.xls is open, then do nothing
if B.xls is not open, then open B.xls

that's it
i'm just not sure how to set the code to do it
any help would be great :)
thank

--
georgi
-----------------------------------------------------------------------
georgio's Profile: http://www.excelforum.com/member.php...fo&userid=1644
View this thread: http://www.excelforum.com/showthread.php?threadid=31907