Hi everyone,
I have a pdf file containing pages of same formatted invoices. I need to write a VBA code to extract customer ID, invoice number and amount due.
The customer ID has a distinct pattern. It has 10 alphanumeric characters starting with a letter "I".
The invoice number starts with the word "invoice number:"
The amount due starts with the word "amount due"
I have thousands of these invoices in one pdf file. What would be the simplest vba code to extract these? Thanks a lot.
I have a pdf file containing pages of same formatted invoices. I need to write a VBA code to extract customer ID, invoice number and amount due.
The customer ID has a distinct pattern. It has 10 alphanumeric characters starting with a letter "I".
The invoice number starts with the word "invoice number:"
The amount due starts with the word "amount due"
I have thousands of these invoices in one pdf file. What would be the simplest vba code to extract these? Thanks a lot.
