Excel Process

[louisa888]

hi,
I have a problem with the excel process. I have started the excel application like this

Dim oExcel As Application
Dim oSheet As Worksheet
Set oExcel = Excel.Application
Set oBook = oExcel.Workbooks.Open(FileName)
Set oSheet = oBook.ActiveSheet
.... after doing some functions...
oBook.close
oExcel.Quit
Set oSheet = nothing
Set oBook = nothing
Set oExcel = nothing

however, when i check the process, it is still running. How can I solve this problem?

 

[SkipVought]

Hi,
What's happnin' in your functions?

While things seem to be waiting, try hitting the Esc Button and see where your procedure is processing. Skip,
metzgsk@voughtaircraft.com

 

[dave8011]

hi,

I use

Application.Quit

to completely shutdown excel.

Hope it helps .

dave