I have a pdf with a table [ 100 rows and 4 columns] .
4th column in the table is having hyperlinks
My requirements is to capture the table with all the contents and store it in the excel.
I was able to achieve this using data scraping and write range.
Issue : but the problem is the hyperlinks are not lost in the excel. Only link text is moved but links are lost.
Can you please give some ideas to solve this problem.
My following requirement is to click on that link from each cell and go to that URL to capture particular information from that webpage and store it in the same excel in a new column.
Greatly appreciate all your inputs.