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