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.
 
Top