Excel 2002 Workbooks.Open failed.

[richmarin]

I had a macro that worked just fine in 97. Then I went to Excel 2002.

When I run the same macro, the commanded Workbooks.Open failed. The
exact error is :

Run-time error '1004':

Method 'Open' of object 'Workbooks' failed

What is going on! Even when I record a key stroke macro, and I run the
recorded macro, it fails. That is just wonderful. If I open a
spreadsheet manually, it works. But, if I run a recorded macro. It does
not work.

 

[Tom Ogilvy]

Are macros enabled? If security is set to high, macros are silently
disabled.

 

[Dave Peterson]

You may want to post the code and indicate the offending line.