Extracting Hyperlinks from excel/VBA

Asked Aug 17 '18 at 00:47

Active Jul 07 '20 at 19:44

Viewed 98 times

I have a file that contains hyperlinks I am using (VBA) Hyperlink(1).Address property to get the complete hyperlink

However, i only get partial hyperlink, which is not helpful

when i investigated, i realized that in the actual hyperlink , whenever there is a character '#' excel truncates its process and only returns the portion of hyperlink before #.

this has driven me nuts , is there any way to get the complete hyperlink ?

This is how the URL Appears:

https://cppm9044.ondemand.ca.com/niku/nu#action:projmgr.editResource&odf_return_to=homeActionId&id=5842039

The Code I am using:

Dim h As Hyperlink

For Each h In Selection.Hyperlinks hy = Right(h.Address, 7)

Thanks

edited Jul 07 '20 at 19:44

Martijn Pieters

963,270
265
3,804
3,187

asked Aug 17 '18 at 00:47

Fahadakbar

Improve your question by adding all the code you are using, someone will try to help you and will need more context. – Alessandro Oliveira Aug 17 '18 at 01:03
`#` is a delimiter (see [this answer](https://stackoverflow.com/a/13500078/4088852)). Can you edit the question to include your code and a sample that is being truncated? – Comintern Aug 17 '18 at 01:04
[See this also.](https://support.microsoft.com/en-us/help/202261/you-cannot-use-a-pound-character-in-a-file-name-for-a-hyperlink-in-an) – Comintern Aug 17 '18 at 01:27
thanks guys i just added the URL and the code i am using – Fahadakbar Aug 20 '18 at 16:03
okay guys, i found the issue.... what a relief... after # is a subaddress :-) – Fahadakbar Aug 20 '18 at 16:06

Extracting Hyperlinks from excel/VBA

0 Answers0