Reliable way to open PDf, copy contents and paste it to Excel

[Snoopy2003]

Hello,

I copy contents of multiple PDF files into Excel.
Right now I open each one of the files by using the following code, and copy the contents by send keys.
After coping I use snd keys to quit acrobat.

How can I open acrobat only one time, open & copy a file, analyze it using VBA (without close acrobat) and the continue with the next input file ?

Thank you for your help

Please Login or Register  to view this content.

[Snoopy2003]

Hello,

In addition to my question - Can you recommend on a reliable way to open PDF, select all content and paste it in Excel or to text file ?
I tried send keys but it does not work every time.

Thank you for your help