I'm trying to print a single page from a spreadsheet to "Microsoft Office Document Image Writer" and save the file for future use.
The code below works, but the print document is produced on screen too.
Is there a method to stop the print document appearing on screen??
Thanks
Application.ActivePrinter = "Microsoft Office Document Image Writer on Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Microsoft Office Document Image Writer on Ne01:", Collate:=true, _
PrToFileName:="C:\Documents and settings\farrowm\Desktop\Noms\BEL.tif"
The code below works, but the print document is produced on screen too.
Is there a method to stop the print document appearing on screen??
Thanks
Application.ActivePrinter = "Microsoft Office Document Image Writer on Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Microsoft Office Document Image Writer on Ne01:", Collate:=true, _
PrToFileName:="C:\Documents and settings\farrowm\Desktop\Noms\BEL.tif"