I've got several Excel 2003 applications that use VBA and contain hundreds of workbooks. Most of the workbooks are created daily and they are data linked to the Personal.xls macro workbook and also to another workbook. Other workbooks are created each month and they are data linked to the previous month workbook and to the next month workbook (if it has in fact been created).

The current paths for these links, under XP, is something like 'C:\Documents and Settings\username\My Documents\subfolder\subfolder'. If I upgrade my OS, the path for these links changes to something like 'C:\Users\username\Documents\subfolder\subfolder'.

Is there a way to migrate all of these workbooks so that the data links are preserved? I know I will have to change some VBA code.

Thanks.