Q1(a) Given the following format, Select region, save as pdf with name "Cash Receipt"
Download file and try:View Answer
Q1(b) Make each file-name unique
Change pdf name to "Cash Reciept 123", here Receipt number is the number that is filled in the sheet.View Answer
Change "D:\Cash Reciept.pdf" to "D:\Cash Reciept number " + Range("number").Text + ".pdf"