A
alasdair_gifford
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
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