Thread: Test if a workbook is open already
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kieran1028[_19_] Kieran1028[_19_] is offline
external usenet poster
  
Posts: 1
Default Test if a workbook is open already

Chip, your code worked (again).

Although I did need to add the line
WB.Activate
After the ISWorkbookOpen = True line.

Thanks (again)!


--
Kieran1028
------------------------------------------------------------------------
Kieran1028's Profile: http://www.excelforum.com/member.php...o&userid=15678
View this thread: http://www.excelforum.com/showthread...hreadid=319442

Reply With QuoteReply With Quote