vba sourcecode to convert pdf to xls

[ro.koehler]

Hello,

Does anybody know a home page where an example of a vba source code is
listed, which enables to convert a pdf file (with tables) into an xls
file.

I would need some ideas how to do this, in order to write my one little
vba programme.

Thanks in advance

Rudolfo

 

[Pete_UK]

You would normally use some OCR software to achieve this - the PDF file
can be read by the software and turned into editable text - or Adobe
Acrobat full version (not just the Reader). I'm not sure how you would
do it with VBA.

Hope this helps.

Pete

 

[NIMISH]

Another crude way is to select text in PDF file and then copy / paste
to notepad and then import them in Excel with proper parsing /
delimeter etc.

But it is very very crude. Sort of quick and dirty solution.

Nimish