Ardus Petus wrote...
Sorry I've been a bit abrupt.
You should consider searching microsoft.public.excel.links
Abrupt but accurate.
Changing links in .XLS file require opening those .XLS files, changing
the links, and saving the files. There is no reliable alternative.
That said, the task would be made MUCH EASIER if the OP created a table
containing all original workbook full pathnames in one column and their
corresponding new full pathnames in the next column to the right. Then
use a macro to open these files one at a time, iterate through the
workbook's LinkSources(xlExcelLinks) array, use VLOOKUP with each
link's current full pathname to find the corresponding new full
pathname from the table, use the ChangeLink method to change the links,
then save and close the workbook.
I suppose these workbooks would reside both in shared directories on
file servers as well as on users' local/nonnetwork drives. If so, IT
staff should convert the server-based workbooks. As for local
drive-based workbooks, there's no alternative to opening and changing
workbook files one at a time, but it can be automated. Still, it could
take a fair chunk of time. Up to users to decide whether to take the
time needed or fix their files on an ad hoc basis on their own.