vba sourcecode to convert pdf to xls ro.koehler[ at ]gmx.de 28.09.2006 07:18:05 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

Re: vba sourcecode to convert pdf to xls "Pete_UK" <pashurst[ at ]auditel.net> 28.09.2006 12:36:59 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 ro.koehler[ at ]gmx.de wrote: [Quoted Text] > 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

Re: vba sourcecode to convert pdf to xls "NIMISH" <parikhnd[ at ]yahoo.com> 28.09.2006 18:14:42 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 ro.koehler[ at ]gmx.de wrote: [Quoted Text] > 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