<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

 Q1(a) Given the following format,  Select region, save as pdf with name "Cash Receipt"

 Save a given Format as pdf  - Macros

 

Download file and try:

-a-

-ea-


 

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.


-a-

Change "D:\Cash Reciept.pdf" to "D:\Cash Reciept number " + Range("number").Text + ".pdf"

 -ea-

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
Jail