Printing to a file - Appending

[bubbafish]

Anyone have any suggestions as how to print to a PDF file and every time you print it would append to the file?

I have a macro that inputs a code in one cell and the sheet loads new data via a lookup. My macro then prints the table and a series of updated charts. The macro then goes to the next code and does the same thing. I would like to save the prints to 1 pdf file so it could printed later or distributed later.

Thanks!

 

[shg]

Nothing for appending when printing, but see http://www.experts-exchange.com/Web_Development/Document_Imaging/Adobe_Acrobat/Q_21228461.html for merging PDFs after printing.