Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Sheet to PDF via Macro Code
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Sheet to PDF via Macro Code
Here is how you call the prineter you want to use
Application.Activeprinter = "NAME OF PRINTER" -- Roland "Simon" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Sheet to PDF via Macro Code
Thanks. Is it possible to save the file as a .pdf through macro code? If
so, how would you do that? "Roland" wrote: Here is how you call the prineter you want to use Application.Activeprinter = "NAME OF PRINTER" -- Roland "Simon" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Sheet to PDF via Macro Code
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. -- Roland "Simon" wrote: Thanks. Is it possible to save the file as a .pdf through macro code? If so, how would you do that? "Roland" wrote: Here is how you call the prineter you want to use Application.Activeprinter = "NAME OF PRINTER" -- Roland "Simon" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help to code Macro to Copy fron one sheet and paste in other sheet | Excel Programming | |||
Printing macro code | Excel Programming | |||
Need a simple printing macro code | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
MACRO OR VBA CODE TO PREVENT USERS FROM PRINTING THE CONTENTS OF A WORKSHEET? | Excel Programming |