Copy specific data from PDF file to excel sheet

[sahil20]

Hi,

I would like to know if the following is possible by using macro(VBA) :

Steps:
1) Open a pdf file on a button click.
2) Search for a specific word in the pdf file which will be specified in the workbook.
3) On finding the specified word in pdf file ,copy data related to the searched keyword from pdf to excel.

for e.g : say i have a column A in excel sheet where name is stored and i want to search that name in pdf file and then i have to copy the id,address and phone number for that particular name only, back to the excel sheet in columns B,C and so on...

If it works for 1 pdf then it would help me a lot working for muliple pdf's at a time.

Thanks in advance.

 

[par60056]

Welcome to the forum.

Extracting data from PDF is not an easy thing to do. PDF draws the document. So the part of the PDF that draws the adjacent column is not always next to the word you searched for.

I have not had much luck trying to extract data from PDF in a usable way.