get some in specific data from pdf file to excel file

[pratmacro]

i have one pdf file having 2000 pages but i need to find some data in pdf get some data on the basis of searching and saved those data in excel. is this possible in VBA?. can you give me VBA code for that.

Thanks,
Prat

 

[Macropod]

No one could possibly give you code for extracting data from a PDF without detailed knowledge of the PDF's contents, it's structure and precisely where & how you want the data stored in Excel. From your description, it also appears you'll need to have Adobe Acrobat Pro installed, so it could be automated from Excel. For an example of what might be involved - even without automation (because the contents were being manually copied & pasted from the PDF into a text file) - see: PDF to Excel - Page 3

 

[pratmacro]

hi i am able to open the pdf file but i don't know how to activate the search tab of pdf in vba code. can you please advice on that?

 

[Macropod]

hi i am able to open the pdf file but i don't know how to activate the search tab of pdf in vba code. can you please advice on that?

Please read my previous post again and pay close attention to the part about automation.