Select All from PDF, Copy --> Paste into Excel

[pivotpp]

Hi all,


Spent the entire Sunday researching this to no avail yet.


In my excel spreadsheet, I simply have a column of URL link that leads to a PDF page in Internet Explorer.


I want to accomplish the following:


1 - For each link > OPEN


2 - Select all from the IE/pdf


3 - Paste into the adjacent cell


4 - Repeat Loop


I know how to data scrape from a standard IE webpage with html tags, but this is a PDF in a Internet Explorer window.




Any thoughts/advice much appreciate.


Thanks all