G
Guest
I'm trying to create a macro that will examine the active workbook and
generate a new sheet listing any cells that contain links to external
workbooks. I know that I can see what the links ARE, as in the name and path
of linked workbooks. What I'd like to do in addition to this is see what
cells use those links.
For instance, I already have code that can tell me that a given workbook has
a link to the file C:\external.xls
But suppose that in the active workbook, Sheet1 Cell D15 has the function
"=HLOOKUP($E$15,'C:\[external.xls]Sheet3'!$D$4:$L$25,A23,FALSE)"
I'd like to include that cell reference (and ideally, that function) in the
report. Short of examining every cell in the workbook for a function that
contains "C:\external.xls", I don't know of any other methods. I'd appreciate
any suggestions. Thanks.
generate a new sheet listing any cells that contain links to external
workbooks. I know that I can see what the links ARE, as in the name and path
of linked workbooks. What I'd like to do in addition to this is see what
cells use those links.
For instance, I already have code that can tell me that a given workbook has
a link to the file C:\external.xls
But suppose that in the active workbook, Sheet1 Cell D15 has the function
"=HLOOKUP($E$15,'C:\[external.xls]Sheet3'!$D$4:$L$25,A23,FALSE)"
I'd like to include that cell reference (and ideally, that function) in the
report. Short of examining every cell in the workbook for a function that
contains "C:\external.xls", I don't know of any other methods. I'd appreciate
any suggestions. Thanks.