New Forum | Previous | Next | (P-PDF) Beginners
Topic: Excel Macro report to Single PDF File
Conf: (P-PDF) Beginners, Msg: 154455
Date: 9/22/2006 02:32 AM
I have an Excel workbook with a macro formula that I use to print out a 60-page product report. One worksheet (product report )has a macro that will run a screen update for each product using a range on another worksheet that contains all the product names. On each screen update the product report worksheet will refresh with data tied to a product in the range on the name worksheet and will cycle through, printing a page for each product with its respective data until the macro is complete.
I have Adobe Acrobat and the Adobe Distiller software and am trying to find a way in which I can either create macro that captures each page of my report that is printed and throw them all into a single PDF file or generate all 60-pages, each as PDFs and then somehow convert them all to a single PDF. Obviously the first method is the method of choice for me but I would accept any other advice to get this to work.