Excel or Web Browser

[riskassure]

Hi,

Is there a VBA code that can tell whether I am opening my Excel spreadsheet in Excel, or in a Web Browser, like IE?

I tried

Applicaton.name

but it always gives me Microsoft Excel as the answer, whether the spreadsheet is opened in Excel or in a web browser.

Any help will be appreciated!

~~CW~~

 

[UnsolvedCoding]

I don't remember the exact location but did run across something like this on the Mr. Excel website.

 

[PHV]

Did you try Application.Parent ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886