Unanswered: Using VB6.0 How do I make sure the Excel Process in my Task Manager disappear.
The code below is what I use to start and end using and excel db. However after each Process has started it remain in my Process List and the file is still in use. I believe the changes (if any) also do not save completely. Any ideas on why this is,
'Declaring Excel Database
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheetAD As Excel.Worksheet
Dim oRng As Excel.Range
' Start Excel and get Application object.
Set oXL = CreateObject("Excel.Application")
'oXL.Visible = True
' Get a new workbook.
Set oWB = oXL.Workbooks.Open("C:\abc.xls")
Set oSheetAD = oWB.Worksheets(1)
'Code in Between
'Quiting the Process
Set oRng = Nothing
Set oSheetAD = Nothing
Set oWB = Nothing
Set oXL = Nothing