'Option Explicit' should only appear ONCE at the top of the module.Ī. 'Double Click' on the module you want to access in the 'Project Explorer'.Į.

CTRL-R to get project explorer (if it isn't already showing).ĭ. 'Left Click' on any cell in the Excel Spreadsheet.Ĭ. With the immediate window open, each time a 'debug.print' line is accessed, there should be a new line of data in the Immediate WindowĪ. After you get to line: If sDataLine1 Like '*25 Marks & Numbers*' Then, put the cursor over sDataLine1 and you should see the contents of the first line of the text fileĮ. Press f8 to single step through the procedure.ĭ. If not, cut and paste what you see and post it.ī. Press Ctrl G to open the immediate Window. If that happens everything should be working OK.Ī. The Macro should stop twice (follow instructions on screen to continue) and should print out data on line 6. In VBA access module ModExtractDataFromPdfFileī.Double Click ExtractDataFromPdfFileConvertedToTextUsingPdtToTextDotExe (on line 8)Ĭ. Download the new file - which is the same with some debugging features added.Ī. Here are a couple of tips to help you figure out what is wrong. When all is working well, you should be able to click the 'Clear' and 'Run' yellow shapes in my file, and the results should pop up instantaneously. If you did so, and the file was in the same folder as my file everything should have worked. I am assuming you renamed to output of file pdftotext.exe (and not the pdf file) to 'Jean1972Data.txt'. I am glad you got file pdftotext.exe to work.

Extract data from pdf to excel