Q1(a) Given the following format, Select region, save as pdf with name "Cash Receipt"
Download file and try:
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"
