Automated Printing of a Report

L

Lamar

Here is what I would like to do (all in VBA Code) when a user hits a cmd
button to print a report:

Change from the default printer for the report (stDocName) to the Microsoft
Office Document Image Writer' printer.

Print the report (stDocName) to a directory defined in 'strPathWay'. So it
prints directly to file in a given folder.

Name the report automatically. This could be defined in 'strFileName'.

I would like to do this without the user having do anything. Is this even
possible? I need to print the report as a TIF file. I wish MS had an
OutPutMethod for reports to be output to TIF files.

Any help you can give would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top