Links Source Lost When Macro Run

[timbo1957]

Hi,

The macro below has been working fine for many years in Excel 2003. If finds last week file which would be 101114 Summary.xls, loads it and changes the name to 171114.xls.

However I now have Excel 2010 and when I run it the status of some (not all) of the links in the workbook change from OK to Error: Source Not Found.

The only change I have made is changing the File to a .xlsx file from .xls

Any advice much appreciated.

Please Login or Register  to view this content.