[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

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
0
zack4x4
Asked:
zack4x4
  • 3
  • 2
1 Solution
 
jason987Commented:
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now