| 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 |
| 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) | |||
![Per[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
