Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: xlDialogPrint

  1. #1
    Join Date
    10th December 2004
    Posts
    4

    xlDialogPrint

    I am trying to use the xl Print Dialog withn VBA code. I've looked up the "arguments" list for XLDialogPrint but have no idea of the proper form of the passing of arguments. For example, I want the dialog box to pop up with print-what = Selection. Cannot find an example or decoding ring for all the xlDialogPrint arguments? Any help would be appreciated.
    Mike

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

    Re: xlDialogPrint

    Hi Mike

    Welcome to ozgrid.com

    The arguments, in order, are

    range_num, from, to, copies, draft, preview, print_what, color, feed, quality, y_resolution, selection, printer_text, print_to_file, collate

    See: Built-In Dialog Box Argument Lists in the Excel VBA help.

  3. #3
    Join Date
    10th December 2004
    Posts
    4

    Re: xlDialogPrint

    Thanks Dave, but I already knew that and how to find the arguments within the help system. But I can not find an example of a line of code passing the arguments (exact format). I also cannot find the choices for each argument.
    Mike

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

    Re: xlDialogPrint

    They are numbers and it takes quite a bit of trial and error.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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