Hi,

I coded a VBA macro in an Excel 97 workbook that imports
data from several diferent excel 97 workbooks into the one
master book (master book contains the macro).

We are now in the process of migrating to Office XP. When
the macro is run in XP, I recieve the following error:

"Runtime Error 1004 -- Application Defined or Object
Defined Error"

The macro ran error free for several months in 97, so I am
confident that this error is due to the change in version.

Any suggestions or ideas on what could be causing this
error?

Thanks.

John.