I have a simple macro to open file #1, copy the file, and paste the data
into file #2. The macro is saved within file #2. We are on a networked
system. When I run the macro on my pc, the macro works without
complications. When a co-worker tries to run the macro, the macro will not
open file #1. Does anyone have any insight on why the macro will work for
one of us and not the other?

Note: I am running Excel 2000 and the co-worker is running Excel 2003.