open the workook with the reference, open the xla, save the xla to th enew
folder, save and close the workbook

" wrote:

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