print to pdf with vba


J

J Wait

How do you print to pdf in VBA and tell it where to save the pdf file and
what to name the pdf file. I can save as pdf in vba, but this does not pdf
the file correctly (different tabs save as different sizes in pdf and it's a
mess). Only printing (not saving) to pdf does it correctly.

When I record myself, it records:
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
 
Ad

Advertisements

Ad

Advertisements

S

Stephan Kassanke

J said:
How do you print to pdf in VBA and tell it where to save the pdf file and
what to name the pdf file. I can save as pdf in vba, but this does not pdf
the file correctly (different tabs save as different sizes in pdf and it's a
mess). Only printing (not saving) to pdf does it correctly.

When I record myself, it records:
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Click to expand...
I used pdfcreator a lot for generating (aka printing) PDFs from VBA.

http://sourceforge.net/projects/pdfcreator/

Samples are included as far as I know. Have a look at
http://www.dailydoseofexcel.com/archives/2006/05/12/excel-pdfcreator/
for further assistance.

Stephan
 
You must log in or register to reply here.

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

Printing to PDF using VBA 2
Using VBA to print to a PDF 1
VBA and PDF 1
Excel VBA to print a chart as a pdf file 2
Print To Pdf From Vba And Name File 0
using excel vba to print a pdf file 6
VBA to open a PDF, print, then close - Stumped 2
Excel VBA to print a chart as a pdf file 1

Top