In case you can't see your other post, Jake Marx posted this and I think it
is probably what you want:

Does your code look like this?

Workbooks("ABC.xls").Sheets("Sheet1").Range("A1"). Value=1

If so, change it to:

ThisWorkbook.Sheets("Sheet1").Range("A1").Value=1

ThisWorkbook will always return a reference to the workbook in which the VBA
code resides, so you don't have to worry about name changes.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

"Mike" wrote in message
oups.com...
Tom,

My Macro doesn't have a code! My macro just performs few operations
using Tools, Macro, Record New Macro...etc.

I opened ABC.xls file and saved it as, using saveas, as DEF.xls

Next, I pushed the button that my macro is linked to but gave me again
an error "out of range" and the file closed!
HOW can I prevent this?

Thanks,
Mike