Planet PDF Forum Archive

Planet PDF ForumWowsers! This is page is old, head to the LIVE Planet PDF Forum. It features more than 10 conferences, covering everything from beginner to in-depth developer and pre-press discussions. If you wish to continue... one & two archive covers 1999-2011 (160,000 pages).


New Forum | Previous | Next | (P-PDF) Beginners


Topic: Excel Macro report to Single PDF File
Conf: (P-PDF) Beginners, Msg: 154455
From: hoveyhome
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.


PDF In-Depth Free Product Trials Ubiquitous PDF

Debenu Aerialist

The ultimate plug-in for Adobe Acrobat. Advanced splitting, merging, stamping, bookmarking, and link...

Download free demo

Debenu PDF Tools Pro

It's simple to use and will let you preview and edit PDF files, it's a Windows application that makes...

Download free demo

Back to the past, 15 years ago! Open Publish 2002

Looking back to 2002, it's amazing how much of the prediction became a reality. Take a read and see what you think!

September 14, 2017
Platinum Sponsor





Search Planet PDF
more searching options...
Planet PDF Newsletter
Most Popular Articles
Featured Product

Debenu PDF Aerialist

The ultimate plug-in for Adobe Acrobat. Advanced splitting, merging, stamping, bookmarking, and link control. Take Acrobat to the next level.

Features

Adding a PDF Stamp Comment

OK, so you want to stamp your document. Maybe you need to give reviewers some advice about the document's status or sensitivity. This tip from author Ted Padova demonstrates how to add stamps with the Stamp Tool along with related comments.