I’m NIRANJAN V T from Bannari Amman Institute of Technology, Tamil Nadu. Focusing on UIAutomation.
Curenty we’re upto develop a bot to download PDF files by accessing hyperlinks given in Excel Sheet.
We Tried So Far.,
Data table - but that gave only normal text, hyperlink is lost
Read cell - Looping becomes trouble
BalaReva’s Extract Hyperlink activity - We used it, no error identified but while displaying with a message box we got “String”
We’ve done about Excel application Scope , we got nothing, but the Error.!
Our Major need is how to access multiple hyperlinks given by column in a Excel Sheet
Is there any updated Activities for this?
How to convert Excel Sheet into a data Table
#We Need a looping idea to iterate through hyperlinks
We look forward to hearing from you guys soon.