How print from preview page without clicking on print buttton

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

With this command excel is not printing but it goes to preview page where I
need to click on print button for printing how can I print without clicking
on print button on preview page continue. Please give me the code (program )
to continue with print.

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=True, Collate:= _
True
 
Vijay,

Set the preview parameter to False, i.e.:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=False, Collate:= True

BTW- looking up the PrintOut method in the online help could have got you
the answer quicker!

Cheers,
Dave
 
Back
Top