Event ThisWorkbook_Startup Does Not Fire

J

Jimmy Q Lu

We have an Excel Template solution developed using Visual Studio Tools for
Office 2005 that has a custom control on the Action Pane. When the user
clicks on a link in IE the Excel document will be generated on the server and
sent to client browser. On the browser side, Excel will load the document and
the Action Pane with the custom control will show as expected. Normally the
user will need to work with more than one document at a time by clicking a
second link and loading the next excel document with the previous document
still on display. The problem we are having now is that the second excel
document will be loaded without any errors but the Action Pane contains no
custom controls. So what we have here is that only the first document with
the expected Action Pane; the rest of the documents with an empty Action
Pane. Our tests indicate that the event ThisWorkbook_Startup for the second
instance forward has never been fired which explains why the custom controls
weren't loaded. What makes it interesting is that when we used Mozilla
Firefox browser everything works. With Firefox, we can have multiple excel
workbooks each with its own custom Action Pane. What we couldn't figure out
was how to make it work in IE. Please help!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top