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. 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("E xcel.Applicatio n")
Set myBook = myExcel.Workboo ks.Open(Current File)
myExcel.Display Alerts = False
myExcel.Feature Install = False

myBook.PrintOut

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

Response.Redire ct "print2.asp?typ e=" & 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
http://www.rlbsolutions.com
lh*****@rlbsolu tions.com

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

Nov 17 '05 #1

Subscribe Reply

2056

Similar topics

2327

Printing documents from an Access form?

by: Tony Williams | last post by:

I have an Access database that we use as a document index system. The documents can be Word, Excel, pdf's etc I have a command button on a form that opens the document in whatever program is relevant. The code I use is Private Sub Cmdstart_Click() On Error GoTo Err_Handler Dim strPath As String If IsNull(DocURLtxt.Value) Then strmsg = "You must enter the Document URL to use this function

Microsoft Access / VBA

1626

Printing in C#

by: ywchan | last post by:

Hi, all I have the following questions about printing in C# 1. How to print a document (e.g. MS Word, Excel, PDF) through C#? I have use PrintDocument and set the DocumentName to the file path (e.g. @"C:\Test.doc"). But I can't print out the content in the document...Why? So how can it print the document? 2. How to convert a document to raw print file (i.e. the same output as "print to file") by using C# code? Any idea / any classes I...

C# / C Sharp

814

ms office printing from web page

by: Daniel Malcolm | last post by:

I am looking at building a CRM solution and would prefer to develop a .net web application rather than a desktop app. A web interface would work well for editing and displaying data. However there are a number of printing requirements, such as printing address labels and creating mail-merged letters for individual customers in the database. Although it would be simple to create HTML documents that are correctly formatted and laid out...

ASP.NET

1103

Help with Automated Mail Merge

by: Kaytrim | last post by:

I have an application that puts data into an Excel spreadsheet. It then opens a Word doc that reads the data and either prints the resulting form letters or keeps the file open for viewing. This uses Office XP and worked fine until I applied SP3. now it crashes with the following error. "Requested object is not available" The crash occurs when I try to set the MailMerge.Destination. If I skip setting the destination the following message...

Visual Basic .NET

1090

Hanging automated Office program

by: Benny | last post by:

I have an automated application to manipulate multiple Office documents. When the process is opening the documents, some of them run into security issues, macro errors, and anything else that produces an unexpected dialog. As a result the process hangs until the dialog is closed. I dont have direct access to the code of the application so I need to make a background process that detect if a dialog is produced while opening documents. I am...

C# / C Sharp

1709

Automated process hanging waiting for dialog

by: Benny | last post by:

I have an automated application that opens and manipulates Office documents. Every time a document triggers a dialog to pop up, the process waits for the dialog before it continues. After a little research, it seems like I will need to use hooks and messages in the Win32 API. Does anyone know how I could go about catching when a dialog is porduced and sending it a message to close? Any ideas are more than appreciated considering this...

C# / C Sharp

8839

How to print .PDF files in the background using C#

by: S_K | last post by:

Hi, I have a directory full of a number of .PDF files that I need to print. Is there any simple way to do this? Using PdfReader purhaps? Thanks in advance. Steve

ASP.NET

2064

How to open word file on background for process.

by: Ang | last post by:

Hi, I want to open a word file on background instead of showing the process on client's screen. And then do mailmerge, after that allow user to saveas. (user simply click the button and IE will ask user to open or save as the file) Below is the code but I donno how to do it on background. It's an aspx program, thanks.

C# / C Sharp

2033

Reports printing with a green background??

by: JeffP | last post by:

A customer is reporting that all reports are printing with a greeny background. When previewed they have what looks like a light-grey background. I can see this as they are not local. They say other things like Word documents print fine, only the Access reports are doing this. They print fine on my system. They all are formatted for white backgrounds. This is a 2000 database. They are using 2003. I have used the db in 2003 and

Microsoft Access / VBA

9521

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10107

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9945

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9900

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9765

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7324

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6599

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5214

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3442

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP