witsonjoyet
Board Regular
- Joined
- Sep 13, 2013
- Messages
- 100
Good Day,
This is Witson, i am pretty new for this VBA. I prepare Invoices in Excel and export it in PDF and save it, as well as i print the original copy and send it to my clients. My Invoices has been already formatted in Excel sheet (Print Area has defined for each Sheet). Now the problem is for the duplicate and triplicate copies. Every time i need to stamp on the 2nd and 3rd copies of the invoices as Duplicate Invoice and Triplicate Invoice. (Duplicate Invoice is for our filing purpose as Office received copy)
Could any one please help me to write a macro that automatically print Duplicate and Triplicate Copies if i select Two Copies while printing.
The first copy of the print should print as it is.
The Second copy of the Invoice print area should show my Duplicate copy object (as received copy) instead of stamp
The Third Copy of the Invoice should print Invoice along with Triplicate copy object.
and i need to save all the copies as PDF.
Thanks in Advance.
This is Witson, i am pretty new for this VBA. I prepare Invoices in Excel and export it in PDF and save it, as well as i print the original copy and send it to my clients. My Invoices has been already formatted in Excel sheet (Print Area has defined for each Sheet). Now the problem is for the duplicate and triplicate copies. Every time i need to stamp on the 2nd and 3rd copies of the invoices as Duplicate Invoice and Triplicate Invoice. (Duplicate Invoice is for our filing purpose as Office received copy)
Could any one please help me to write a macro that automatically print Duplicate and Triplicate Copies if i select Two Copies while printing.
The first copy of the print should print as it is.
The Second copy of the Invoice print area should show my Duplicate copy object (as received copy) instead of stamp
The Third Copy of the Invoice should print Invoice along with Triplicate copy object.
and i need to save all the copies as PDF.
Thanks in Advance.