lost reference to activesheet when opening workbook inside IE
 

I have created an Excel (2003) using a VB Form for data input (and
validation), which, after the user finishes with entering information,
returns values to the sheet behind it, in order to carry on with calculations.

The problem now is that users started calling this Excel from IE: a web page
links to the Excel, they click the link and the Excel file opens inside IE,
as an embedded object to the web page.
When opened like that, the form I am using inside the Excel loses access to
the worksheet object model behind it:
the reference to the "Activesheet" now returns an error 91 (object variable
or with block.....)

How can I regain access to the Worksheet object model from the form, when
Excel is opened inside IE?

lost reference to activesheet when opening workbook inside IE
 

This may not be a good solution for you...

I'd do my best to not let MSIE open the file:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059

There are just too many things that don't work when an excel file is opened in a
browser.

vsiat wrote:

I have created an Excel (2003) using a VB Form for data input (and
validation), which, after the user finishes with entering information,
returns values to the sheet behind it, in order to carry on with calculations.

The problem now is that users started calling this Excel from IE: a web page
links to the Excel, they click the link and the Excel file opens inside IE,
as an embedded object to the web page.
When opened like that, the form I am using inside the Excel loses access to
the worksheet object model behind it:
the reference to the "Activesheet" now returns an error 91 (object variable
or with block.....)

How can I regain access to the Worksheet object model from the form, when
Excel is opened inside IE?

--

Dave Peterson