Automated Background printing of Office Documents

[Lee Harris]

Hello,
I have a client that has about 150 users on a intranet that I've
created. The server is Windows 2000 with IIS 5.0 and has Office 2000
installed. The client came to me and asked if it was possible to print
MS Word and Excel docuements right from the ASP page. First I said sure
I'll just link the document to the page then you can print it. That's
not what they wanted, they wanted to be able to click on a link and have
the server print off the document in the background. Easier said then
done.

Well I searched Microsoft KB articles intill I came across an article
about just that Automated Background printing of Office Documents.
However Microsoft has a notice that this solutions is not supported
because of the high load on the servers. Now I'm looking for any
solution that you might know of that will allow background printing with
more stability. If you know of any components or code writen in ASP
that would be great. My current code is as follows.


<%
On Error Resume Next
Dim myExcel
Dim myBook
Dim rs
Dim CurrentFile


currentfile = Request ("file")

Set myExcel = CreateObject("Excel.Application")
Set myBook = myExcel.Workbooks.Open(CurrentFile)
myExcel.DisplayAlerts = False
myExcel.FeatureInstall = False

myBook.PrintOut

mybook.close 2
Set myBook = Nothing
myExcel.Quit()
Set myExcel = Nothing

Response.Redirect "print2.asp?type=" & Request ("type")
%>

The problem I get is when the document is closing, it doesn't seem to
completly close the Excel application. Any suggestions are welcome

Thanks in advance
Lee

________________________________________
Lee Harris
Internet Solutions Developer
15 Lewis Road
Guelph, Ontario
N1H 1E9, Canada
p:519.822.3450
f:519.822.9212
[url]http://www.rlbsolutions.com[/url]
[email]lharris@rlbsolutions.com[/email]


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Lee Harris]

Hello,
I have a client that has about 150 users on a intranet that I've
created. The server is Windows 2000 with IIS 5.0 and has Office 2000
installed. The client came to me and asked if it was possible to print
MS Word and Excel docuements right from the ASP page. First I said sure
I'll just link the document to the page then you can print it. That's
not what they wanted, they wanted to be able to click on a link and have
the server print off the document in the background. Easier said then
done. Well I searched Microsoft KB articles intill I came across an
article about just that Automated Background printing of Office
Documents. However Microsoft has a notice that this solutions is not
supported because of the high load on the servers. Now I'm looking for
any solution that you might know of that will allow background printing
with more stability. If you know of any components or code writen in
ASP that would be great. Or even ASP.NET would be great if some code
exists. My current code is as follows.


<%
On Error Resume Next
Dim myExcel
Dim myBook
Dim rs
Dim CurrentFile


currentfile = Request ("file")

Set myExcel = CreateObject("Excel.Application")
Set myBook = myExcel.Workbooks.Open(CurrentFile)
myExcel.DisplayAlerts = False
myExcel.FeatureInstall = False

myBook.PrintOut

mybook.close 2
Set myBook = Nothing
myExcel.Quit()
Set myExcel = Nothing

Response.Redirect "print2.asp?type=" & Request ("type")
%>

The problem I get is when the document is closing, it doesn't seem to
completly close the Excel application. Any suggestions are welcome

Thanks in advance
Lee

________________________________________
Lee Harris
Internet Solutions Developer
15 Lewis Road
Guelph, Ontario
N1H 1E9, Canada
p:519.822.3450
f:519.822.9212
[url]http://www.rlbsolutions.com[/url]
[email]lharris@rlbsolutions.com[/email]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Mark Andrews]

Our company has developed a application which runs Microsoft Access
on the server and monitors a table to tell it which reports to run.
We have a component that the ASP page uses to write records to the table.

You could easily change the source code to automate Word or Excel.

Note: Currently our server-side EXE is written in VB6 and does run in the
foreground
so the server must be logged on. You could change this to a service.

Take a look it might help you with an approach. Our solution only runs one
instance
of Access and is very stable. Spawning Office applictions from ASP can
cause problems
if you get concurrent usage.

HTH,
Mark
RPT Software
[url]http://www.rptsoftware.com[/url]



"Lee Harris" <lharris@rlbsolutions.com> wrote in message
news:%231OTVIXRDHA.212@TK2MSFTNGP10.phx.gbl...

> Hello,
> I have a client that has about 150 users on a intranet that I've
> created. The server is Windows 2000 with IIS 5.0 and has Office 2000
> installed. The client came to me and asked if it was possible to print
> MS Word and Excel docuements right from the ASP page. First I said sure
> I'll just link the document to the page then you can print it. That's
> not what they wanted, they wanted to be able to click on a link and have
> the server print off the document in the background. Easier said then
> done.
>
> Well I searched Microsoft KB articles intill I came across an article
> about just that Automated Background printing of Office Documents.
> However Microsoft has a notice that this solutions is not supported
> because of the high load on the servers. Now I'm looking for any
> solution that you might know of that will allow background printing with
> more stability. If you know of any components or code writen in ASP
> that would be great. My current code is as follows.
>
>
> <%
> On Error Resume Next
> Dim myExcel
> Dim myBook
> Dim rs
> Dim CurrentFile
>
>
> currentfile = Request ("file")
>
> Set myExcel = CreateObject("Excel.Application")
> Set myBook = myExcel.Workbooks.Open(CurrentFile)
> myExcel.DisplayAlerts = False
> myExcel.FeatureInstall = False
>
> myBook.PrintOut
>
> mybook.close 2
> Set myBook = Nothing
> myExcel.Quit()
> Set myExcel = Nothing
>
> Response.Redirect "print2.asp?type=" & Request ("type")
> %>
>
> The problem I get is when the document is closing, it doesn't seem to
> completly close the Excel application. Any suggestions are welcome
>
> Thanks in advance
> Lee
>
> ________________________________________
> Lee Harris
> Internet Solutions Developer
> 15 Lewis Road
> Guelph, Ontario
> N1H 1E9, Canada
> p:519.822.3450
> f:519.822.9212
> [url]http://www.rlbsolutions.com[/url]
> [email]lharris@rlbsolutions.com[/email]
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!