I'm starting a new Vb.Net project and I will be using Office Automation
(Excel only) with a web service to open and prints excel docs for users.

How can I be sure excel closes after it prints and if it doesn't how do I
forcibly close excel without rebooting the server or stopping the Web service?

John,
Have you tried:
Application.Quit?

Henry


"John" wrote in message
...
I'm starting a new Vb.Net project and I will be using Office Automation
(Excel only) with a web service to open and prints excel docs for users.

How can I be sure excel closes after it prints and if it doesn't how do I
forcibly close excel without rebooting the server or stopping the Web
service?

I'm looking to use this If excel locks up or has an an unknown message. Will
application.Quit still close it without causing problems in the webservice if
Excel has an unknown message or wont respond?

"Henry" wrote:

John,
Have you tried:
Application.Quit?

Henry


"John" wrote in message
...
I'm starting a new Vb.Net project and I will be using Office Automation
(Excel only) with a web service to open and prints excel docs for users.

How can I be sure excel closes after it prints and if it doesn't how do I
forcibly close excel without rebooting the server or stopping the Web
service?

John,

Sorry, I don't know the answer to that one. I've no experience with
webservices.
Application.Quit is the usual way to quit Excel and is fairly bombproof.
However, if there is a problem with the webservice, I have no idea what the
effect will be. I suppose that would depend on what the problem with the
webservice is. Could you arrange for the webservice to time out after Excel
closes?

Henry


"John" wrote in message
...
I'm looking to use this If excel locks up or has an an unknown message.
Will
application.Quit still close it without causing problems in the webservice
if
Excel has an unknown message or wont respond?

"Henry" wrote:

John,
Have you tried:
Application.Quit?

Henry


"John" wrote in message
...
I'm starting a new Vb.Net project and I will be using Office Automation
(Excel only) with a web service to open and prints excel docs for
users.

How can I be sure excel closes after it prints and if it doesn't how do
I
forcibly close excel without rebooting the server or stopping the Web
service?

John,
Have you tried this

Dim E1 As Excel.Application

E1.Application.Workbooks(<name).Close()

I am trying to call a web service from an Excel VB application also.
However, when I define the usernameToken before I call the web service, I get
a runtime message "Execution Permission Cannot be Acquired". Have you run
into this?
Thanks
Guha

"John" wrote:

I'm starting a new Vb.Net project and I will be using Office Automation
(Excel only) with a web service to open and prints excel docs for users.

How can I be sure excel closes after it prints and if it doesn't how do I
forcibly close excel without rebooting the server or stopping the Web service?