Capture user input into xldialog print

[vpanang]

hello everybody

I need some help with vba for excel.

I using the excel print dialog box to print my active sheet. I need a
way to capture how many copies that the user entered in the print
dialog box to print.

I need to keep track of the number if copies printed. Any help will be
really appreciated

Thanks
Vinod

 

[Guest]

To the best of my knowledge, that information is not available through any
built in methods.

 

[Kletcho]

You can use Workbook_BeforePrint event to track how many times they are
printing, but I don't think you can catch the number of copies printed
through VBA. You might be able to use the windows API "PrinterDLG",
but I am not that familiar with the windows API's. Maybe someone else
in the group knows more?

 

[vpanang]

Thanks Tom and Kletcho for taking time to reply to my question.

May be I should try a workaround wherein I prompt the user to selec
the number of copies before they hit Ctrl+P and then transfer tha
selection over to the "nof copies" field inside the print dialo
box.

Thanks again guys