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.

Istvan wrote:

I got some strange situation.
I have an excel workbook with a macro. When i download the file, everything
works fine. However when i choose "Open" in IE7 the macro crashes with the
following message:
Runtime error '1004':
Method 'Sheets' of object '_Global' failed

I've been able to make it work by inserting a wait of 1 second.

However, i don't really like this solution, as it leaves me guessing on what
the real cause is, and how to solve it properly.

Any suggestions?

--

Dave Peterson