Hi all,

I have the following problem: I'm have a set of workbooks (office 2003)
and an XLA in a folder. The workbooks contain a reference to the XLA. I
copy this folder to a new location. The reference to the XLA is still
the one in the original folder and not the XLA in the new folder, too
bad, because this is what I want.

So, from VBA code in the workbook_open event I remove the reference and
add a new reference specifying the path to the XLA in the new folder.
But still, when I check the reference it is once again to the XLA in
the original folder!

anybody an idea how to get it to the XLA in the copied folder?

Regards, Sam