How to let the user select a printer and then print?

[MBaas]

Hi all,

I wrote a little program which fires up Excel through COM, opens an
XLT, fills it with data, prints it and closes Excel, all happening
automatically without any user-interaction. Now I was asked to add a
possibility to select a printer after Excel is started, so that all
printouts would go to that specific printer.
Is there a way to call a SelectPrinter (or whatever) method which would
enable me to do so?

Thanks

Michael

 

[Abdul]

Try this

Application.Dialogs(xlDialogPrint).Show

Thanks

Abdul

 

[Chris Lewis]

Hi all,

I wrote a little program which fires up Excel through COM, opens an
XLT, fills it with data, prints it and closes Excel, all happening
automatically without any user-interaction. Now I was asked to add a
possibility to select a printer after Excel is started, so that all
printouts would go to that specific printer.
Is there a way to call a SelectPrinter (or whatever) method which would
enable me to do so?

Thanks

Michael

Try application.Dialogs(xlDialogPrinterSetup).Show

This should change the active printer to the one selected in the dialog.

 

[MBaas]

Thanks Abdul & Chris - works beautifully and does exactly what I wanted


Cheers

Michael