Step 6: Apply cleaning to arrange the data properly into the rows and columns to change the design of the table.Step 5: The exported data into Excel is displayed, as shown in the figure.Step 4: Then, click on the “Export to Excel” option.Step 3: Select the “convert to” drop-down menu and choose the “Microsoft Excel Document (*.xlsx) format.The following steps are followed to extract the data using Microsoft word.
#VBA PDF SEARCH TEXT PAGE NUMBER PDF#
#2 Extract PDF Data to Excel Using Microsoft Word
#VBA PDF SEARCH TEXT PAGE NUMBER PRO#
'Note! This only works with Acrobat Pro installed on your PC, will not work with Readerĭim AcroApp As CAcroApp, AcroAVDoc As CAcroAVDoc, AcroPDDoc As CAcroPDDocĭim AcroHiliteList As CAcroHiliteList, AcroTextSelect As CAcroPDTextSelectĭim PageNumber, PageContent, Content, i, j, iNumPages 'Note: A Reference to the Adobe Library must be set in Tools|References! SearchResult = AdobePdfSearch("my search string", "C:\Demo\Demo.pdf")įunction AdobePdfSearch(SearchString As String, strFileName As String) As String Hope this is helpful to someone in the future. It returns the matches for all pages separated by commas. It searches page by page, not word by word, so it will find multi-word matches and words with dashes (case insensitive). The function below is acceptably fast, even on very large documents. I never found anything that truly met my needs so I made something up by combining several different resources. I know this is an old question, but it was one of the top search results when I was looking for the same info.