Need advise to copy from pdf to exel if possible

[hendrikbez]

Hi
I nead to know if this is possilbe, I have 7 Pdf files ond each one have+- 6500 pages, on each page there is certain info that I need to put in an one excel sheet.

it looks like this

2017-12-15 08_37_28-172.22 Network Scan.pdf - Foxit Reader.png

VMSA-2015-0007: VMware ESXi OpenSLP Remote Code Severity: 10.0 (High)
Execution (remote check)

Hostname: 172.00.00.11 = pra@@@@@@.com

there is only one line also I need to put this in excel like this

Host name Ip Adress Finding Severity Severity
pra@@@@.com 172.00.00.00 VMSA........ 10.0 High

Hope there is a way, as I do not want to copy and paste everthing.

I did ask this question on mrexcel https://www.mrexcel.com/forum/excel-...-possible.html
but did not get respone form there

[Keebellah]

Hi, I have done it but it's not straight forward.
Have you googled for possible solutions?
Similiar questions have been postend en many forums one of these is Stackoverflow
https://stackoverflow.com/questions/...d-to-worksheet

I found a file on another forum (http://www.vbaexpress.com/kb/getarticle.php?kb_id=1101) maybe it can point you in the rigth way.

Hope you can work something out. The code I wrote was for a specific PDF file with a clear identifiable table but it still took quite some time to make it work.