![]() In addition, I suggest your download Notepad++ (programmer's editor - GNU no cost license) to view the contents of the text file: īe patient, we will figure out what is wrong.Ĭongratulations on getting everything to work. A variable value will be displayed by putting the cursor over the variable name. ![]() To conditionally set a BREAKPOINT at a certain location put in lines similar to: To automatically set a BREAKPOINT at a certain location put in the line: ![]() Select View > Locals to see all variables while debugging. Press CTRL 'G' to open the IMMEDIATE WINDOW. 'Left Click' the margin to the left of a line to set (or clear) a BREAKPOINT.Į. Press CTRL 'F8' to stop at the line where the cursor is.ĭ. Press SHIFT 'F8' to single step OVER subroutines and functions.Ĭ. Press 'F8' to single step (goes into subroutines and functions).ī. '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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |