Fow can I call File>Print from a VBA macro?

[MCubitt]

Having set up page setup detail, I'd like to emulate the File>Print action for the user, how can I do this, please?

thanks


Applications Support
UK

 

[Loomah]

Hi
If you want your user to interact with the print dialog then you can use
Application.Dialogs(xlDialogPrint).Show

but if you just want to print without user interaction have a look at the PrintOut method.

Happy Friday

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[MCubitt]

I think I'll give them the interaction, so they can choose a printer and things.

Thanks for your help, it worked.



Applications Support
UK