How to force ExcellApp.Quit( ) when it's actually called?

[sherifffruitfly]

Hi,

I load the contents of an excel sheet into a dataset via the excel
object library (couldn't get the #$%#$^ oledb/ado route to work -
#^$%&^%$ connection strings... grrr.... )

Anyway, after I get the sheet's contents into my dataset, I'd love to
jettison excel. Calling ExcelApp.Quit() has no effect until I exit the
entire application. How can I force excelapp.quit() to take effect when
the line is executed?

thanks!

cdj

[Stuart King]

Hi cdj,

Are you operating Excel through Late Binding?

I had similar issues to the ones you describe and found that Marshall.Releas eComObject did the trick.

Hope it helps

Stuart King
Informology Ltd.

"sherifffruitfl y" <sh************ *@gmail.comwrot e in message news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

Hi,

I load the contents of an excel sheet into a dataset via the excel
object library (couldn't get the #$%#$^ oledb/ado route to work -
#^$%&^%$ connection strings... grrr.... )

Anyway, after I get the sheet's contents into my dataset, I'd love to
jettison excel. Calling ExcelApp.Quit() has no effect until I exit the
entire application. How can I force excelapp.quit() to take effect when
the line is executed?

thanks!

cdj

[sherifffruitfly]

Stuart King wrote:

Hi cdj,

Are you operating Excel through Late Binding?

Hi Stuart -

Thanks for the reply.

My project's references to the Excel 11.0 object library are added
before I compile - I take it that's a "no" to your question?

[Stuart King]

Hi cdj,

I've tried the approach I gave you using the Microsoft Office
references(Earl y Binding) and in fact it still gives the desired effect. I
tried it out in a button click handler on a form. The following code does
nothing fancy, all it does is show Excel, waits for 5 seconds then quits
Excel again. If you use Task Manager you should be able to see the excel
process coming alve and then being unloaded from memory

private void button1_Click(o bject sender, EventArgs e)

{

Microsoft.Offic e.Interop.Excel .ApplicationCla ss App = new
Microsoft.Offic e.Interop.Excel .ApplicationCla ss();

App.Visible = true;

System.Threadin g.Thread.Sleep( 5000);

App.Quit();

System.Runtime. InteropServices .Marshal.Releas eComObject(App) ;

}

Hope this helps.

Stuart King

Informology Ltd.

"sherifffruitfl y" <sh************ *@gmail.comwrot e in message
news:11******** **************@ f16g2000cwb.goo glegroups.com.. .

>
Stuart King wrote:

>Hi cdj,

Are you operating Excel through Late Binding?

Hi Stuart -

Thanks for the reply.

My project's references to the Excel 11.0 object library are added
before I compile - I take it that's a "no" to your question?

[sherifffruitfly]

Stuart King wrote:

System.Runtime. InteropServices .Marshal.Releas eComObject(App) ;

That line (which I didn't understand the first time you mentioned it)
solved all problems.

Thanks a million!

cdj