Q1(a) Given the following format, Select region, save as pdf with name "Cash Receipt"
Download file and try:
Something went wrong!
The
video
couldn't load due to a technical hiccup.
But don't worry — our team is already on it, and we're working hard to get it back up ASAP.
Thanks for bearing with us!
Something went wrong!
The
video
couldn't load due to a technical hiccup.
But don't worry — our team is already on it, and we're working hard to get it back up ASAP.
Thanks for bearing with us!
Something went wrong!
The
video
couldn't load due to a technical hiccup.
But don't worry — our team is already on it, and we're working hard to get it back up ASAP.
Thanks for bearing with us!
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"
Something went wrong!
The
video
couldn't load due to a technical hiccup.
But don't worry — our team is already on it, and we're working hard to get it back up ASAP.
Thanks for bearing with us!