Printing Sheet to PDF via Macro Code

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi,

I have an excel worksheet that I would like to be able to print to pdf
through some macro code. The PDF printing application that I'm using is PDF
reDirect v2, does anyone have any ideas as to how I can go about printing the
sheet with Macro Code?

Thanks.
 
Here is how you call the prineter you want to use

Application.Activeprinter = "NAME OF PRINTER"
 
Thanks. Is it possible to save the file as a .pdf through macro code? If
so, how would you do that?
 
Simon

The easiest way to teach yourself is to go into the spreadsheet record a
macro while doing the procedure you want then read the code and take out the
pieces that are applicable.
 

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

excel sheets to PDF 1
Macro for all Excel Workbooks to print to PDF 2
PDF export add-in 2
Publish as PDF/XPS Strange 1
Printing to pdf 3
Printing to File (PDF) 6
Print all tabs to a pdf file 1
Change PDF Properties via Excel Code 1

Back
Top