Choosing a printer using VBA

  • Hi folks!


    I'm currently writing a macro in VBA that will print out a selection of worksheets. The macro works fine, except that I don't know how to set it up so that the user is prompted to choose from the list of printers (as you would normally do when printing).


    Also, does anyone happen to know if there is any code I can use to ask the print-outs to be configured to fit the page better (ie. automatically set the zoom).


    Many, many, many thankyous to anybody with advice on this one!


    Cheers
    Johno

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!