Getting a Macro to Print

  • Thread starter Thread starter Gogs
  • Start date Start date
G

Gogs

I have a macro which will print out a report for me. I
want it to do this without any user intervention at all.
However it will print out the report & then display a
dialog box about "print definitions" if I click Ok it
prints an additional page with the macro details on if I
click cancel it doesn't print this page out (which is how
I want it). I've tried Setwarnings=No in the macro but it
still displays the dialog box. Is there any way I can
either not display the print definitions dialog box or by
getting the macro to "click cancel" for me?

Thanks in advance

Gogs
 
Post the macro actions that you're using. I haven't seen the problem that
you describe in my macros.
 
Hya Ken,

I found out the solution on Office Experts Forum. But
just for your info:

Setwarnings:no
OpenReport:File Still With Dr
Printout:All
Quit

the solution involved using an open event code on a form
which ran the macro & for some reason (I don't know code
very well)

Thanks for the offer of help anyway.

Gogs
 
Back
Top