Global Printings

by Gary Chalupa
gchalupa@inetnebr.com

In this example I take the basic concept described earlier and use it
in a more efficient way to print on a regular basis. This makes for
quicker print times and less strain on the server. Instead of
creating a new application object each time you print, you create it
in the Global.asa as an application object.

In this example I take the basic concept described earlier and use it
in a more efficient way to print on a regular basis. This makes for
quicker print times and less strain on the server. Instead of
creating a new application object each time you print, you create it
in the Global.asa as an application object. Then each time you print
you only need to create a new document. This means that you have
Word and/or Excel running constantly, but it means that you won’t
have multiple copies running, and that it doesn’t need to start each
time you print.

This is based on the following two
articles.
Printing
Excel Documents from ASP
Printing
Word Documents from ASP

You will need to follow the
preliminary steps outlined in one of
the other articles as well. I will not place the source code
here, but in a zip file. It is fully commented, and follows the same
concept as the other examples. You can download it here.

I
used ideas from a couple of different places to put this together
and I need to mention them.
Excel and
ASP
by: Armand Datema

Word and
ASP
by: Armand Datema

Using
ASP and WSH to Print on Your Intranet
by: Jeff
Sandquist

Formatted Output
using ASP
by: David R. Cline

Q184291
– PRB: COM Objects Fail to Print When Called From
ASP
Microsoft Corporation

Download the code here: globalprint.zip