Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print to File
I want to control the printer output, when I am sending a print output to a file as shown in my code below. How do I select the destination directory and the filename without entering text in the popup textbox, and how do I suppress the popup textbox, so that the program continue uninterrupted
Range("A1:F63").Selec Application.ActivePrinter = "Generic PostScript Printer on FILE: Selection.PrintOut Copies:=1, ActivePrinter:= "Generic PostScript Printer on FILE:", Collate:=Tru ActiveWorkbook.Sheets("SCAN").Activat pe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print to File
Per
There is a PrintToFile argument and a PrToFileName argument to the PrintOut method. I believe if you set the former to True and specify the latter, you won't get prompted. Note that PrToFileName was added in XL2000 and won't be available in older versions. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Per" wrote in message ... I want to control the printer output, when I am sending a print output to a file as shown in my code below. How do I select the destination directory and the filename without entering text in the popup textbox, and how do I suppress the popup textbox, so that the program continue uninterrupted. Range("A1:F63").Select Application.ActivePrinter = "Generic PostScript Printer on FILE:" Selection.PrintOut Copies:=1, ActivePrinter:= _ "Generic PostScript Printer on FILE:", Collate:=True ActiveWorkbook.Sheets("SCAN").Activate per |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my excel is converting all my print jobs to print to file why? | Excel Discussion (Misc queries) | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
Can view file in print preview, but not print layout.... | Excel Discussion (Misc queries) | |||
print and print preview not active in file drop down | Excel Discussion (Misc queries) | |||
How do I print from a file created from sending a print to a file | Excel Discussion (Misc queries) |