Results 1 to 16 of 16

Run-time error '429' ActiveX component can't create object

Threaded View

  1. #1
    Registered User
    Join Date
    07-15-2009
    Location
    Rockford, IL
    MS-Off Ver
    Excel 2003
    Posts
    38

    Run-time error '429' ActiveX component can't create object

    Hi,
    I am trying to generate excel report output from access by click of a button. Part of the code is as follows:
    Dim lngColumn As Long
    Dim xlx As Object, xlw As Object, xlc As Object
    Dim DBS As DAO.Database
    Dim rst As DAO.Recordset
    Dim blnEXCEL As Boolean, blnHeaderRow As Boolean

    blnEXCEL = False

    'If we do not want the first row we set Header to false
    blnHeaderRow = False

    'Establish an EXCEL application object
    On Error Resume Next
    Set xlx = GetObject(, "Excel.Application")

    If Err.Number <> 0 Then
    Set xlx = CreateObject("Excel.Application")
    blnEXCEL = True
    End If
    Err.Clear

    I worked on development on a server and worked fine. However when I have moved the code and database to the desktop of mine I am having
    the following error in the line

    Set xlx = GetObject(, "Excel.Application")
    I cannot figure out how to fix this. I appreciate any help for resolution. Thanks.


    Run-time error '429'
    ActiveX component can't create object
    Last edited by gamaz; 01-26-2010 at 07:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1