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.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

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

End If
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


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.