How do I print various sheets from a spreadsheet to PDF via VBA

R

rghunt

At the click of a button I need to print several sheets (all with their
parameters set) from a spreadsheet to 1 PDF file of filename equal to a cell
on one of the sheets.

Presently I have a procedure that, when called, prints all the required
sheets to a network printer. I have duplicated this procedure, and attempted
many different configurations to print to the Adobe PDF (printer)...no go.

The second part of the task. Once the PDF file has been created, I need it
to be e-mailed to a specific "distribution list" in Outlook. As Adobe has
"Convert to PDF and E-Mail" as an option, I'm sure that this part can also be
accomplished.

I have Adobe Acrobat 6.0 Professional installed and Excel2002 (as part of
Office XP)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Print (physical or pdf) not respecting format of source document 0
Images are pixelated when saving to PDF 0
VBA Export to PDF 0
excel sheets to PDF 1
Loosing transparency effect of Master Page graphic when Saving Publisher files as .pdf 0
Converting excel to PDF, single page converts to multiple HELP! 1
Script to print to pdf a word document with pdf linked as objects 5

Top