Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to pdf by code
I have looping code that makes various changes to an Excel
file, prints it, changes it again, prints it again and so on for 100 iterations. This works fine for printing to my network printer. But when I print to Acrobat Distiller or PDF Writer, I then have to wait by my PC and hit "Save" each time it comes to print - 100 times. Can someone please tell me how to print to pdf and execute the Save prompt so I can leave my PC to work while I go and have a cup of tea? Thanks in advance, Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to pdf by code
Hi,
Use something like that in your Macro. Static intN As Integer Sheets("Sheet1").Select Application.ActivePrinter = "Acrobat PDFWriter on LPT1:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Acrobat PDFWriter on LPT1:", PrintToFile:=True, PrToFilename:="ThePDF" & Trim(Str(intN + 1)) intN = intN + 1 Have a nice cup of tea -- JP http://www.solutionsvba.com "Daniel Bonallack" wrote in message ... I have looping code that makes various changes to an Excel file, prints it, changes it again, prints it again and so on for 100 iterations. This works fine for printing to my network printer. But when I print to Acrobat Distiller or PDF Writer, I then have to wait by my PC and hit "Save" each time it comes to print - 100 times. Can someone please tell me how to print to pdf and execute the Save prompt so I can leave my PC to work while I go and have a cup of tea? Thanks in advance, Daniel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to pdf by code
Thanks! (to someone who understands the need for a nice
cup of tea) -----Original Message----- Hi, Use something like that in your Macro. Static intN As Integer Sheets("Sheet1").Select Application.ActivePrinter = "Acrobat PDFWriter on LPT1:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Acrobat PDFWriter on LPT1:", PrintToFile:=True, PrToFilename:="ThePDF" & Trim(Str(intN + 1)) intN = intN + 1 Have a nice cup of tea -- JP http://www.solutionsvba.com "Daniel Bonallack" wrote in message ... I have looping code that makes various changes to an Excel file, prints it, changes it again, prints it again and so on for 100 iterations. This works fine for printing to my network printer. But when I print to Acrobat Distiller or PDF Writer, I then have to wait by my PC and hit "Save" each time it comes to print - 100 times. Can someone please tell me how to print to pdf and execute the Save prompt so I can leave my PC to work while I go and have a cup of tea? Thanks in advance, Daniel . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |