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?