How print from preview page without clicking on print buttton

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Print problems w/ charts excel 2003/2007 3
form with print preview 2
Print Code Help 5
Printing Macro 1
BeforePrint & PrintPreview Hangs 1
Print to PDF format 4
Print two different areas on a worksheet 4

Top