get information from Print dialog

[Wes]

How do I access the # of copies that a person has chosen
after they hit print on the print dialog box?

My program prints a page several times, making changes to
several values before each print. The program shows the
print dialog box only for the first time, allowing the
user to choose the printer and the number of copies etc.
It then prints the remaining pages.

How do I set NumCopies (in the code below) to the number
of copies the user chose in the print dialog

Application.Dialogs(xlDialogPrint).Show

.... some other code ...

ActiveWindow.SelectedSheets.PrintOut Copies:=NumCopies,
Collate:=True

Your help would be greatly appreciated. Thanks.

 

[Tom Ogilvy]

The print dialog will do the printing - so you would just be repeating what
it has already done (unless you cancel printing in the before print event).
Built in dialogs only return true or false. You can't get user selections
from them.

Perhaps you need to put up your own userform to get this information.

Regards,
Tom Ogilvy

 

[Wes]

Is it possible to set the print dialog "copies" to be
uneditable?

P.S. the reason I had code to print again after the call
to printdialog is because my program changes some values
on the sheet then reprints it. I've set up the sheet
basically like a database form with the data on a seperate
page.

Thanks.

 

[Tom Ogilvy]

Is it possible to set the print dialog "copies" to be
uneditable?

I doubt it. What is the point of showing the dialog?

As I said, you can cancel the print in the beforeprint event and then manage
the printing yourself, but you can't harvest values from the dialog - so the
question remains, what do you need to accomplish with the dialog?