I need the URL address of an Excel field

[nicol-dayana.arias-lebro]

I’m reading an Excel file using the “Read Range” activity, but I’m running into a problem: some fields contain a URL that isn’t visible. That is, the cell only shows some text, but behind that text there’s a hyperlink.
When the data is retrieved, only the visible text in the cell is returned — not the actual URL.
What would be the best option to also retrieve the URL from those hyperlinks?

[Parvathy (PS Parvathy)]

Hi @nicol-dayana.arias-lebro

Check the below thread.

Read hyperlink from Excel without URL

just use a foreach loop here enumerable.Range(2,11) means start at row 2 and end at row 12 [image] then in the vba call , change the parameter to this [image] also, change the macro.txt to this to handle cells with NO hyperlinks (will output “No Link” if cell has no hyperlink) Function GetURL(cellAddress as string) As String On Error goto ErrorHandling: GetURL = Range(cellAddress).Hyperlinks(1).Address Exit Function ErrorHandling: GetURL = "No Link" End Function macro.txt (194 Bytes) te…

Hope it helps!!