Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to see full path name of open workbook? | Excel Discussion (Misc queries) | |||
How to Display Full Path for File Diplayed at Top Of Workbook | Excel Discussion (Misc queries) | |||
Determining the full path and filename of an active workbook | Excel Programming | |||
Identify Full Path of Opened Excel Workbook | Excel Programming | |||
How to get the full path name of the open workbook in a macro | Excel Programming |