** RESOLVED ** Excel Object Question (Just to add to the pile)

[TheBionicOrange]

OK .... I know there are LOADS of Excel based questions on these forums. I've even answered some of them, but this one is a bit different.

I've done enuff Excel based in VB now to know where to find errors that create EXCEL objects 'on the fly', and I know if you create an Excel object, you have to pretty much prefix EVERYTHING with it to stay out of trouble, but I've just stumbled across something else maybe someone can answer.

EVERY time I run a VB app that uses the Excel object, it leaves an EXCEL process when its finished.

Weirdly though, this only happens on Windows 2000 and Windows XP machines. Run it on 95 or 98 and you don't get a problem

Is there a new 'EXCEL9.OLB' to cover 2000/XP ?

If so I couldn't find one.

The following code is an example, and yes the file does exist :

Private Sub Build_Cus_Enq_1()
    Dim objExcel As Excel.Application
    
    Set objExcel = CreateObject("Excel.Application")
    With objExcel
        .Workbooks.Open "C:\Excel.csv"
        .Visible = True     
    End With
    
    Set objExcel = Nothing
    
End Sub