View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default Check Excel's state to see if a workbook is loaded in App


"Chris w." wrote in message
...
Does anyone know if there is a way to check Excel App. to
see if there is actually a workbook open. I'm refferring
to the conditon where Excel is open but there is no
workbook open (loaded), I would like to cancel code from
running if the App. has no loaded workbook


I guess you could use the ActiveWorkbook property:
http://msdn.microsoft.com/library/de...bjWorkbook.asp

/Fredrik