Activeworkbook and Internet Explorer
 

I have a workbook that gets opened via Internet Explorer. When this happens
and the user does not have Excel already running, Excel launches within IE.
The user then clicks on a button to bring up a form. They make some
selections and then click on a button that takes their selections and posts
it to a given sheet.

The problem is that although the correct workbook is shown and the form
loads properly, when it tries to post the selections back to the book, it
thinks that Book1 is the activebook and no matter what I put into the form
(e.g. Application.Workbooks("MyBook").Activate, etc.) it never activates that
book and so it fails to write back teh results where it should.

The code works flawlessly when run from within native Excel. Does anyone
know how to tell Excel that is within IE to activate another book?

Activeworkbook and Internet Explorer
 

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.

BobT wrote:

I have a workbook that gets opened via Internet Explorer. When this happens
and the user does not have Excel already running, Excel launches within IE.
The user then clicks on a button to bring up a form. They make some
selections and then click on a button that takes their selections and posts
it to a given sheet.

The problem is that although the correct workbook is shown and the form
loads properly, when it tries to post the selections back to the book, it
thinks that Book1 is the activebook and no matter what I put into the form
(e.g. Application.Workbooks("MyBook").Activate, etc.) it never activates that
book and so it fails to write back teh results where it should.

The code works flawlessly when run from within native Excel. Does anyone
know how to tell Excel that is within IE to activate another book?

--

Dave Peterson