Check Excel's state to see if a workbook is loaded in App
 

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

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

Check Excel's state to see if a workbook is loaded in App
 

How about:

If ActiveWorkbook Is Nothing Then
MsgBox "no active workbook"
Exit Sub
End If

At the top of your procedure.

"Chris w." wrote:

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

--

Dave Peterson

Check Excel's state to see if a workbook is loaded in App
 

Hi Chris,

It's not clear how you've opened or are controlling this
instance of Excel, but the following may help (It works as
a sheet event within a workbook in Excel):

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
MsgBox Application.Workbooks.Count
End Sub

App.Workbooks.Count may get you there.

Best Regards,
Walt

-----Original 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
.