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
strAcrobatPath = .Cells(lngSearchStringRow + 1, lngSearchStringCol)
strOpenFilePath = strAcrobatPath & " " & strPDFFileFullPath
'The Shell command
varRetVal = Shell(strOpenFilePath, 1)
'Clear CutCopyMode
Application.CutCopyMode = False
AppActivate varRetVal
Bookmarks