dcmf
(dcmf)
March 23, 2022, 2:35pm
1
Hello
When I use the Extract HyperLinks activity the activity locks the excel document and the notification always appears and because of that the activity never works.
Has anyone who has had this problem managed to find a solution?
jack.chan
(Jack Chan)
March 23, 2022, 2:45pm
2
you can try this to extract URL
first create a txt file e.g. “Data\macro.txt” with this code inside
Function GetURL(cellAddress as string) As String
GetURL = Range(cellAddress).Hyperlinks(1).Address
End Function
in your invoke VBA activity, pass in the cell where you want to read the hyperlink
[image]
assign output to an object variable e.g. “output”
[image]
print output using output.tostring
[image]
My example:
Excel:
[image]
workflow:
[image]
Result:
[image]
TestGetLink.xaml (6.4 KB)
test.xlsx (8.8…
1 Like
Hi @dcmf
Try downgrading the package once
Thanks
1 Like
dcmf
(dcmf)
March 23, 2022, 2:54pm
4
doesn’t work,
the activity error is Extract HyperLinks: No license file
Hi @Foertsch ,
Thank you for you valuable feedback.I had chance to test in various type.Yes it has bug. I have fixed it. you get he package here Version 7.1.0 .
Here i have attached sample for your. But the package is configure in local so. after open the project , configure the package from your local.
Foertsch.zip (47.0 KB)
Thank you
Balamurugan.S
Refer @dcmf above link as well as sample video
Kindly select the package version mentioned in video
Thanks
1 Like