Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Selecting printer (VBA/Excel/2000)

    Stuck again!
    Try as I might, I cannot find an Excel equivalent to the following snippet of Word VBA code:
    <pre> Application.Dialogs(wdDialogFilePrintSetup).Show</pre>


    Can anyone point me to an Excel equivalent code snippet?
    Regards
    Don

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,265
    Thanks
    2
    Thanked 187 Times in 173 Posts

    Re: Selecting printer (VBA/Excel/2000)

    Hi Don,
    I think what you're after is
    <pre>application.Dialogs(xlDialogPrinterSetup).Sho w
    </pre>

    it's not quite the same dialog but I believe it's as close as there is.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Selecting printer (VBA/Excel/2000)

    Hi Rory
    That's exactly what I wanted.
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •