PDF to Excel with VBA?? Is possible???

[Shokan_Prince]

Hi guys...

Is there any way to convert a PDF online document to excel format, using VBA???

 

[Joe4]

There are a number of after market products you can use to convert PDFs to Excel, some free, some not, and some better than others (just do a Google Search on "convert PDF to Excel").
There have also been a number of discussions on this forum about those products.
Note this tip from MrExcel a few years back: Convert PDF to Excel

 

[Shokan_Prince]

Hi Joe, thhx for the quick answer...
The thing here is that I dont have the pdf files pyshically on my hard drive, and i don't want to store it, and using an external software is not what I'm looking for...

Just to give you an idea, I need to convert 16 pdf files per week and I want to avoid the manual labor that represents make it with a program...

 

[Joe4]

I don't know if you are going to be able to work with the PDF if you don't download it, but here are some links that claim to be able to convert PDFs to Excel files.
VBA Macros Code examples: Import a PDF in Excel
vba - pdf to excel conversion putting each pdf page in a different worksheet - Stack Overflow