By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,493 Members | 1,138 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,493 IT Pros & Developers. It's quick & easy.

killing or terminating the excel process

P: 86
dear friends, i am using ms access 2003.

i wanted to export data from access table to excel table.
so i have followed this



Dim db As Database
Dim ea As Excel.Application
Dim rs As Recordset
Dim j As String

Set ea = New Excel.Application
Set db = CurrentDb
ea.Workbooks.Add
ea.Visible = True
Set rs = db.OpenRecordset("SELECT Indicator_Values.year as yea, Indicator_Values.[Energy use per $1 GDP (PPP)(converted unit)]as eng FROM Indicator_Values;")
If rs.RecordCount > 0 Then
rs.GetRows
rs.MoveFirst

For i = 1 To rs.RecordCount
j = rs!Yea
k = rs!eng
ea.ActiveSheet.Cells(i, 1).Value = rs!Yea
ea.ActiveSheet.Cells(i, 2).Value = rs!eng
rs.MoveNext

Next
End If
ea.Workbooks.Close
ea.Quit
Set ea = Nothing



i worked out very well this code. i got what output i want.
but the problem here is even if i close the excel window, i see some excel processes running in the back ground( i viewed it through task manager).

indeed i have closed the excel window with the code

ea.Quit

even then why the excel process still running in the back ground?
how to kill that process?
Jun 2 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.