Print & save

[anil21]

1) click on print & save button save & print the invoice as pdf format with invoice no & customer name in specific folder on computer
I have a excel sheet (invoice copy) which i want to print 3 copies
2)I have a problem with the header that i want to print. The header is
different for all the 3 pages while all the other content remains the
same.
the header of the invoice in the first page to be printed should be "
original for the buyer"
the header of the invoice in the second page to be printed should be
"Duplicate for the seller"
the header in the third page should be " Transporter's Copy"
and so on
I AM SEND VBA CODE FOR CORRECTION PLEASE FIND THE ATTACHMENTS & CORRECT THIS VBA WITH MY REATIL INVOICE
PASSWORD FOR EDIT THIS INVOICE:- 123456
How do i over come this problem
Can anyone help me
Thanks a ton in advance