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
Similar Threads
