Excel 2002 Workbooks.Open failed.
 

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.

Excel 2002 Workbooks.Open failed.
 

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

--
Regards,
Tom Ogilvy


wrote in message
oups.com...

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.

Excel 2002 Workbooks.Open failed.
 

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



wrote:

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.

--

Dave Peterson