Macro Link Does Recognize Open Workbook

  • Thread starter Thread starter Ed P
  • Start date Start date
E

Ed P

I have a macro in workbook "A" that goes to workbook "B"
and copies a worksheet and pastes it into "A". It works
fine on my laptop but when I transfer the workbooks (via
floppy) to another computer and run the macro I get this
message:

"A document with the name "A.xls" is already open. You
cannot open two documents with the same name, even if the
documents are in different folders.
To open the second document, either close the document
that's currently open, or rename one of the documents"

1) I have searched the computer and cannot find any other
files named "A.xls".
2) I have checked the "Edit Links" on the "B.xls" and the
location of the "A.xls" is correct.

What am I missing?
 
Ed,

It sounds like the macro assignment for your button has included the
file path from the old file location. Try re-assigning the macro to
the button after you have opened "A.xls" on your other computer.

HTH,
Bernie
 
Back
Top