How do I get the results of the Excel VBA printer dialog box?

Hi - I was wondering how do I retrieve the printer selected by the user in the excel vba printer dialog box (Application.Dialogs(xlDialogPrint).Show)?

There are multiple reports to print out and I only want the user to have to select the printer once.

Thanks - Zack
LVL 4
zack4x4Asked:
Who is Participating?
 
jason987Connect With a Mentor Commented:
Application.ActivePrinter  seems to be what you are looking for.
0
 
zack4x4Author Commented:
Does that change if the user selects a different printer in the dialog box?
0
 
jason987Commented:
Yes, if they had selected the printer and hit "ok".
0
 
jason987Commented:
I don't know the exact point in which it updates the variable.  As in I don't know if as they are scrolling though them if it changes.
0
 
zack4x4Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.