Automatically change source location of sheet data is linked to.

[neodd70]

This is a little long but I want to explain why my problem is happening. I have a bunch of spreadsheets that have links to a master spreadsheet and they all reside in the same folder. These spreadsheets are used as design tables for Solidworks. When a Solidworks 3D model is opened Solidworks will open the spreadsheet and apply the numbers in the cells to the dimensions in the model. When I save the model from Solidworks it will also save the design table which I've been told is actually an Excel Object in SolidWorks but it will save it as the same name and in the same location that the original Spreadsheet was in. As long as the folder name and path that the spreadsheets reside in doesn't change the links from the spreadsheets to the master spreadsheet remain linked. My issue is if I copy the folder and rename it. When I do this the links in the spreadsheets remain linked to the original location of the master spreadsheet. Right now what I have to do is open all of the spreadsheets including the master and then re-save them, this will re-establish the location in the links to the master spreadsheet residing in the same folder as the other spreadsheets, then I can copy and rename the folder containing the spreadsheets and the links remain ok. This didn't used to be an issue when I was using Excel 2003 but from 2007 on up the links become broken if the spreadsheets are saved from Solidworks. I've been told that this is a security thing with Excel and as of yet there are no fixes. I did read however that a macro could be created using VBA in Excel that would run when the spreadsheet was opened and that macro could in affect change the source location of the spreadsheet that it links to. My issue is that I do not know how to do this. If there is someone here that would be willing to help me I would be eternally grateful. I just need it to tell the spreadsheet that the location of the master spreadsheet it links to is in the same folder it is in. The master spreadsheet name never changes and neither do the names of the spreadsheets that link to it. TIA