Good morning,

I am using an Access 2003 on an XP Pro computer and using an Access module
and an object variable to control Excel and things seem to function w/ no
problems if Excel is open, but if Excel is closed, my code should test to see
if Excel is already open, if not module should launch Excel. This is my code

 Dim OBJ As Object
    On Error Resume Next
    Set OBJ = GetObject(, "EXCEL.Application")
    If ERR.Number <> 0 Then
       ERR.Clear
       Set OBJ = CreateObject("EXCEL.APPLICATION")
    Else: MsgBox ERR.Description
    End If
But I get an error saying "Runtime error 429, Active X component can't
create object." I went to microsoft webiste and looked up the error and
explanation is that "You tried to place an Active X control on a form at
design time or add a form to a project with an Active X control, but the
associated information in the registry could not be found."...."to correct
the problem, the information in the registry may have been deleeted or
corrupted. Reinstall the Active X control or contact the control vendor."
Problem is I don't recall every changing, installing, or messing w/ any
Active X controls. I also have included in my module's references "Microsoft
Active X Data Objects 2.1 Library " and "Microsoft ActiveX Data Objects
Multidimensional 2.7 Library". I am curious, do these at all conflict w/ each
other, must I encorporate a different Active X library, do I need to
reinstall Access, or do I need a service pack update? I am not sure how to
correct this problem. Any suggestions? Thanks. Cordially,