Hi @Moses Kobe - I just wrote a custom code you can add add as action in one of your excel extended objects, you can check params for input and output variables, add any exception handling if you want to-
Dim ws as Object = GetWorksheet( handle, workbookname, worksheetname)
Dim xlRange As Object = ws.Range(Range_Cell)
Dim dt As New DataTable()
dt.Columns.Add("Hyperlinks")
For Each cell As Object In xlRange
If cell.Hyperlinks.Count > 0 Then
dt.Rows.Add(cell.Hyperlinks(1).Address)
End If
Next cell
Output_Collection = dt
Input Excel-
Output -
let me know if you find any difficulties with this.
------------------------------
Regards,
Mukesh K
------------------------------
