What printer is user printing this report to?

  • Thread starter Thread starter UpRider
  • Start date Start date
U

UpRider

Here's the problem I need to solve in vba.
rptMyReport is showing on the screen in preview.

I need to automate as much as possible the naming of a pdf file without user
intervention.

User calls up print dialog
if user chooses any printer except a pdf driver then do nothing more.
if user chooses a pdf driver then
append date to filename "rptMyReport_080805.pdf" 'I know how to
construct this string
endif

So, I need to know what printer a user has chosen, after the print is
committed,
I might need to know when the output file actually exists (I know DIR will
tell me this)
I can either rename the created file adding the appended date (or paste the
complete revised name
into the print dialog if I can get control of it).
It would also be nice to set the path in the print dialog.

and I ESPECIALLY need to know what events could trigger the code so that I
know where to put it.

I'm OK with solutions, ideas or insights, brainstorming is good.

UpRider
 
Back
Top