Skybluekid
Well-known Member
- Joined
- Apr 17, 2012
- Messages
- 1,229
- Office Version
- 365
- Platform
- Windows
Hi
I have a list of Recharges, with PDFs, that are sent to us from our supplier into our inbox. We then receive a download of all the charges, which goes into an excel table. Once the download is complete, I am required to match the recharge number to registration and cost of the vehicle. Currently, I have to do this manually. The registration and cost are in the PDF.
Is there a way to search through the PDF's using vba, given the criteria from the excel sheet?
Thanks in advance
I have a list of Recharges, with PDFs, that are sent to us from our supplier into our inbox. We then receive a download of all the charges, which goes into an excel table. Once the download is complete, I am required to match the recharge number to registration and cost of the vehicle. Currently, I have to do this manually. The registration and cost are in the PDF.
Is there a way to search through the PDF's using vba, given the criteria from the excel sheet?
Thanks in advance