Tell if workbook is opened in IE

[Guest]

Hey Guys,

I was wondering if there is a way I can tell if a workbook that has been
opened is hosted in Interner Explorer.

Ideally what I would like to do is checked if the workbook/ excel
application is hosted in IE on one of the Applciation start up events and
then disable some off my code accordingly.

Thanks for you help.

Regards........Jim

 

[Robert Doisneau]

I was wondering if there is a way I can tell if a workbook that has

 

[Dave Peterson]

In another forum, Jim Rech suggested using ActiveWorkbook.Container.

Ture Magnusson posted this using Jim's suggestion:

Thanks Jim!

Container works perfectly...

Sub CheckIfInInternetExplorer()
'Declare local variable
Dim x As Object

'Try to get container object
On Error Resume Next
Set x = ActiveWorkbook.Container
On Error GoTo 0

'Show result depending on container's typename
Select Case TypeName(x)
Case "Nothing"
MsgBox "The workbook is opened in Excel"
Case "IWebBrowser2"
MsgBox "The workbook is opened in Internet Explorer"
Case Else
MsgBox "The workbook is opened in another application: " & TypeName(x)
End Select

'Clear object variable
Set x = Nothing
End Sub

/Ture