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



richmarin@earthlink.net 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