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.
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
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.