Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 03-14-2006, 05:28 PM
bwjunkie bwjunkie is offline
Novice
 
Join Date: Mar 2006
Posts: 1
bwjunkie
Default excel not closing

i can reproduce this exact same problem with my vb.net application, and have found some interesting semi-solution

i CANNOT get excel.exe to drop out of my process list, when i automate, even trying all the above technique and using all the close/quit functions.

once i fully close my .net application, the processes dissappear.

even if i say .visible=true, and then i close it with the mouse, the process stays open.

when i close my application completely, then the excel.exe process dissappears.

im not using late binding however.
i use the new excel.application with proper office references.

not sure how this info helps, but just FYI

josh
josh at pipeline dot com

sample code below
Dim oxls As Excel.Application
Dim oBook As Excel.Workbook
Dim oSheet As Excel.Worksheet
Try
oxls = New Excel.Application
oxls.DisplayAlerts = False
oxls.Visible = False
oBook = oxls.Workbooks.Open(Me.txtGoodList.Text)
oSheet = oBook.ActiveSheet
Me.SheetToDataset(oSheet, Me.DsGOOD.tList)
oxls.Visible = True
oBook.Close(False)
oxls.Quit()
Catch ex1 As Exception
oxls.Visible = True
oBook.Close(False)
oxls.Quit()
Throw ex1
End Try
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 - Different Header for each page franklyorange Excel 0 08-26-2008 02:26 PM
Powerpoint 2003 - slides with Excel text franklyorange PowerPoint 0 08-19-2008 09:30 AM
Run Outside application from toolbar button Richard Harison Word 3 12-20-2005 03:22 PM
Application not found error when trying to open .pdf files. Dave Outlook 2 12-15-2005 01:01 PM
Excel 2003 will not terminate with application.quit access runtime application will not install markjean Office 1 12-06-2005 02:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft