View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick[_22_] Rick[_22_] is offline
external usenet poster
 
Posts: 2
Default Checking if workbook is open

For Each C In Workbooks()
If C.Name = "Book1" Then MsgBox "Workbook " & C.Name & "
is open ...", vbInformation
Next C

-----Original Message-----
I'm sure I've seen this in the group before but I can't

find it.

How would I check to see if a specific workbook is

already open?

Jesse


.