VBA code for Object printing on second copy

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.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,223,959
Messages
6,175,647
Members
452,663
Latest member
MEMEH

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top