Is there a way to extract all external links and return the file path, workbook, worksheet and cell (e.g. ‘[Workbook]Worksheet’!$A$1?
So far I’m only aware of extracting external links and return file path and workbook.
Asked
Active
Viewed 122 times
0
-
Please add the code you have so far to the question. What kind of external links do you mean? Do you mean when a cell contains a URL? Or if data from a different workbook is linked/referenced? Do you mean the file path, workbook, and cell of the source file or of the target file of the links? – GWD Oct 21 '22 at 09:05