how to apply vba code to select multiple pdf file and read data of only last page of pdfs one by one by power query and give specific data from it to another worksheet like date,challan No.,lorry no.,total qty,total net wt.,total amount. sample pdf is attached for reference.
Bookmarks