Hello, everyone,
I am quite new to vba and have a question about the creation of hyperlinks based on cell values via vba.
The idea is that I have a XLS with which I upload data to a website. For this I create a hyperlink inside the XLS out of a Name, a Origin Link and Link Format, which then my tool read out.
I would like to create the hyperlinks with VBA, but so far I had no success...
The format looks should be look like this:
The hyperlink should be build out of Name and the origin link and the format of iPushExternal like this:
=iPushExternalLink(" & Origin Link & ";" & Name & ")";" & Name & ")
maybe some could help me
I am quite new to vba and have a question about the creation of hyperlinks based on cell values via vba.
The idea is that I have a XLS with which I upload data to a website. For this I create a hyperlink inside the XLS out of a Name, a Origin Link and Link Format, which then my tool read out.
I would like to create the hyperlinks with VBA, but so far I had no success...
The format looks should be look like this:
Name | Origin Link | Link | Hyperlink |
Cat | =iPushExternalLink("http://cdn.publish.macrobond.net/r/d/ 10918/5203d44a6885482a9413a75d45bb494f/chart.png";"Cat")";"Cat") |
The hyperlink should be build out of Name and the origin link and the format of iPushExternal like this:
=iPushExternalLink(" & Origin Link & ";" & Name & ")";" & Name & ")
maybe some could help me