Excel automation in VB.NET problem

[Mark]

G'day Folks,

I have MS visual studio 2003 (2) and have created a small
application using VB and the application uses Excel to
produce reports. My machine has XP and Excel 9.0

There are 3 reports which can be produced and each report
has it's own button to initiate it's creation.

The problem is that i have to completely exit my
application before i can run the next report. It appears
that my application is holding Excel, even after it has
completed the report and passed the application.quit
code. Excel can be started separately while my
application is running and other xls files opened, BUT, i
cannot open other xls files via explorer.

Questions - Has anybody else experienced this issue and
how have you overcome it ?..

Regards, Mark.

 

[Cor]

Hi Mark,

I seldom do interop programming (one of the things is that I had the same
expiriences as you in the past).

But in this newsgroup we cannot see how you did it, so to let people help
you, it is mostly wise to supports some code or to tell wath interop part
you did use.
(The hardware does mostly not inerest us)

By the way, did you already look at this pages:

Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311452

Pia Download
http://support.microsoft.com/default.aspx?scid=kb;EN-US;328912


Cor

 

[Herfried K. Wagner [MVP]]

Mark,

I have MS visual studio 2003 (2) and have created a small
application using VB and the application uses Excel to
produce reports. My machine has XP and Excel 9.0

There are 3 reports which can be produced and each report
has it's own button to initiate it's creation.

The problem is that i have to completely exit my
application before i can run the next report. It appears
that my application is holding Excel, even after it has
completed the report and passed the application.quit
code. Excel can be started separately while my
application is running and other xls files opened, BUT, i
cannot open other xls files via explorer.

<http://support.microsoft.com/default.aspx?scid=kb;EN-US;317109>