Hi all,
Please can anybody help me with a VBA code which can extract the invoice number from pdf and paste in a specific cell in the excel. I have multiple pdfs which are not scanned ones saved in a specific file path. I was looking for a code which will scan through all the pdfs matching the amount that's in column C starting from C15 to a varied range (the range keeps on varying) and paste the respective invoice number in column D (starting from D15). The pdfs has an alphanumeric invoice number. The code will search the text Invoice Number: and then extract the 10 character size invoice number to paste in Sheet 1 of the workbook corresponding to invoice amount.
Thanks
Please can anybody help me with a VBA code which can extract the invoice number from pdf and paste in a specific cell in the excel. I have multiple pdfs which are not scanned ones saved in a specific file path. I was looking for a code which will scan through all the pdfs matching the amount that's in column C starting from C15 to a varied range (the range keeps on varying) and paste the respective invoice number in column D (starting from D15). The pdfs has an alphanumeric invoice number. The code will search the text Invoice Number: and then extract the 10 character size invoice number to paste in Sheet 1 of the workbook corresponding to invoice amount.
Thanks