Code Printing list of hyperlinks in excel file

[reimar_rem]

Any code for printing list of hyperlinks in excel file? sample file attached.

[ranman256]

can you not just do File, Print?

[Zer0Cool]

If you are actually using Excel 2013+, enable the Inquire add-in, click workbook analysis and there is a checkbox for hyperlinks. Will generate a sheet with a list of them that you can print.

Be aware that "hyperlinks in a file" is a very broad term. I am presuming you mean "hyperlinks in cells". The above will give you that. To actually get all the hyperlinks in a file is a monumental task given the many places hyperlinks can be used and the many ways they can be constructed. Its further complicated if by hyperlinks you actually mean links to external data, the difference being a hyperlink traditionally being a clickable link to go to some resource/data and an external link acting as a data source to your workbook.

For example; named ranges and conditional formats can have external links/hyperlinks in them, but would not be shown as hyperlinks by any feature or code I know of directly. Also, there is a HYPERLINK formula, which technically isnt a hyperlink until the function calculates. Combine HYPERLINK with something like INDIRECT and it becomes an even more complex effort. If hyperlink means external link, you have your work cut out for you as cells, named ranges, conditional formats, etc can contain multiple external links in a single cell, name or rule. At that point you have to parse the information and "find" the link/external data source inside of the entire contents.

Maybe if we knew why you wanted to do this we could better help as there could be a better way other than just listing out all hyperlinks.

[xlnitwit]

For your sample workbook, which lists all the file paths and names and all are workbooks, you might simply use something like this

Please Login or Register  to view this content.

[Zer0Cool]

It may be faster to just loop the hyperlink objects in the hyperlink collection, see https://msdn.microsoft.com/en-us/vba...s-object-excel