Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get information from Print dialog
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
get information from Print dialog
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
get information from Print dialog
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. -----Original Message----- 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" wrote in message ... 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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
get information from Print dialog
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? -- Regards, Tom Ogilvy Wes wrote in message ... 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. -----Original Message----- 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" wrote in message ... 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Dialog Box | Excel Worksheet Functions | |||
Print Dialog box | Excel Discussion (Misc queries) | |||
How to create a dialog box to encode information to worksheet? | Excel Discussion (Misc queries) | |||
Collate check box in the Print Dialog Box | Setting up and Configuration of Excel | |||
Dialog box with worksheet information | Excel Worksheet Functions |