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

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

I did what you proposed, but from the VBA editor I can't save the xla
to a new folder? And I'm actualy looking for an automated solution from
a VBA macro or VB6 program.

so here's the problem again:

I have 2 directories (dir1 and dir2) next to each other.
Dir1 contains an xls file
Dir2 contains an xla file

xls refers to xla

when I copy both dirs to another location on my harddrive then the
copied xls refers to the copied xla. This was the case in Office 2000.
Recently I changed to Office 2003. If I now copy both dirs to another
location on my harddrive then the copied xls refers to the original xla
instead of the copied one.

Anyone know what Office2003 does differently than Office 2000 realted
to handling references?

regards, Sam