linking ASP to client MS Word

[Dan Nash]

Hi guys

Basically, I want to be able to print labels and invoices (via MS Word) for
net orders, using our ASP site admin system.

Heres the code I've come up with...

<%
Call OpenDBConnectio n("data")

set labeldata = dConn.Execute(" SELECT * FROM Orders ORDER BY OrderNo DESC")

address = labeldata("Cart ID")
firstline = labeldata("Cart ID")
address = address & vbCrLf & labeldata("Name ") & vbCrLf &
labeldata("Addr ess") & vbCrLf & labeldata("Post Code") & vbCrLf &
labeldata("Coun try")

labeldata.Close ()
set labeldata = nothing

set app = createobject("W ord.Application ")
app.Application .Visible = True
app.Documents.A dd()
app.Selection.T ypeText(address )
app.Selection.W holeStory()
app.Application .MailingLabel.D efaultPrintBarC ode = False
app.Application .MailingLabel.P rintOut "2160 Mini", firstline,
wdPrinterManual Feed, true, 1, 1

Call CloseDBConnecti on()
%>

This works fine with my localhost IIS5, however, I suspect that when I
transfer this to the webserver, it's gonna try and run Word on the server.
What we wanna do is run the code on the server, so that it loads Word on the
client machine and prints the labels.

How can this be done? Any help greatly appreciated!

Cheers
Dan

[Aaron Bertrand [MVP]]

> What we wanna do is run the code on the server, so that it loads Word on
the

client machine and prints the labels.

This is a contradiction. You can't run code on the server that even thinks
about touching Word on the client (yes, even in an Intranet scenario). You
need a client-server application, not a web page, to do this.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/