Thread: Print to File
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Per[_3_] Per[_3_] is offline
external usenet poster
 
Posts: 1
Default 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