![]() |
LinkSources full workbook path
Having a bit of a problem with the LinkSources property. I have a
procedure that opens a workbook with links in it, uses 'ActiveWorkbook.LinkSources(xlExcelLinks)' to pick up the linked workbooks and then opens them. However some of the links are coming up as only being stored with the workbook name, not the full path (all the workbooks are in seperate folders) causing an error. I think this is because of how I set-up some of the links when the workbooks were closed, editing the forumla then redirecting the link with the update values dialog box. Am I using the wrong property? If so does anyone know the right one? Best of all would be a link to a property listing (can't find one in help or on the msdn website). Regards Giff |
LinkSources full workbook path
Sorry, my mistake, I had some dodgy links. All sorted, procedure works
fine. |
All times are GMT +1. The time now is 06:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com