Excel 2002 and IE7

[Istvan]

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]

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]

Thx for your answer Dave, unfortunately, that's not an option.

The Excel file is publicly available via a website, i have no idea who will
open it and with what configuration. On top of that, the data it contains
changed every 3 months. So forcing a download might result in users
forgetting to download the latest version and thus making mistakes. It's a
file about contribution and reduction rates, so it's important they get it
right.