print & save

[anil21]

i am creat a print & save button save & print the invoice in PDF format with invoice no & customer name and save the invoice in d:/invoice folder/Anil kumar 0001.pdf
I have a single excel sheet (invoice copy) which i want to print 3 copies
The invoice in the first page to be printed should be
"original for buyer"
The invoice in the second page to be printed should be
"Duplicate for seller"
The third page should be " Transporter's Copy"
and so on
How do i over come this problem
Can anyone help me
Thanks a ton in advance

 

[-JC-]

Are you doing the titles for the three docs as the contents of a cell?If so you could always do:

Range("A1").Select    
  ActiveCell.FormulaR1C1 = "Original for Buyer"
    'your print code here    
  Range("A1").Select    
  ActiveCell.FormulaR1C1 = "Duplicate for Seller"
    'your print code here    
  Range("A1").Select    
  ActiveCell.FormulaR1C1 = "Transporter's Copy"
    'your print code here

edit: can't get it to format properly, hopefully it makes sense still

 

[anil21]

i am creat a retail invoice & 1 am creat a print & save button& print the invoice in PDF format with invoice no & customer name and save the invoice in d:/invoice folder/Anil kumar 0001.pdf
I have a single excel sheet (invoice copy) which i want to print 3 copies
The invoice in the first page to be printed should be
"original for buyer"
The invoice in the second page to be printed should be
"Duplicate for seller"
The third page should be " Transporter's Copy"
and so on
How do i over come this problem
Can anyone help me
Thanks a ton in advance
example: anil kumar is the buyers
0001 is the invoice no.
save in pdf format
please halp us