View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Print to MODI but not display viewer?

I am using Office 2003 on Windows XP.

I am using the following code to print an Excel spreadsheet to a TIF FILE by
using MODI. However, each time this runs, it opens the viewer. I don't want
the viewer to load at all.

Could someone please fix my code or post some example code that would keep
the viewer from opening (or close the viewer after it opens)?

ActiveWindow.SelectedSheets.PrintOut _
Copies:=1, _
Preview:=False, _
ActivePrinter:="Microsoft Office Document Image Writer on Ne00:", _
PrintToFile:=True, _
Collate:=True, _
PrToFilename:="c:\test1.tif"

Thanks much in advance.