Results 1 to 3 of 3

Thread: Error=429: ActiveX component can't create object

  1. #1
    vibhub Guest

    Error=429: ActiveX component can't create object

    I am creating a VB6 application to export data from MsAccess to Excel. It works fine on Windows XP Pro but gives an error "Error=429: ActiveX component can't create object" on Vista Home Premium. The development machine has Excel 11 where as the client machine has Excel 12. I included Excel 11 in the installer package.

    I have included the code that gives the error....

    ' Excel object variables
    Dim appExcel As Excel.Application
    Dim wbk As Excel.Workbook
    Dim wks As Excel.Worksheet
    Dim sTemplate As String
    Dim sTempFile As String
    Dim sOutput As String

    ' Create the Excel Applicaiton, Workbook and Worksheet and Database object
    Set appExcel = New Excel.Application
    Set wbk = appExcel.Workbooks.Open(sOutput)
    Set wks = appExcel.Worksheets("Sheet1")

    Thanks & Regards,

    Vibhu Bansal
    http://www.ITSYSSolutions.com
    Last edited by vibhub; 23-12-2008 at 11:26 AM. Reason: Added more information to the problem

  2. #2
    George Bashore Guest

    Re: Error=429: ActiveX component can't create object


  3. #3
    vibhub Guest

    Re: Error=429: ActiveX component can't create object

    I am using ADO2.1 in the project and not DAO. Does this still hold good?

    Thanks & Regards,

    Vibhu Bansal
    http://www.ITSYSSolutions.com - Solutions for business.

Similar Threads

  1. ActiveX component can't create object error
    By Abe Simpson in forum Windows x64 Edition
    Replies: 8
    Last Post: 14-06-2011, 11:32 PM
  2. Error 429 : ActiveX component can't create object
    By GunTher in forum Vista Help
    Replies: 8
    Last Post: 30-01-2011, 03:04 AM
  3. Error=429 : ActiveX component can't create object
    By SurnameS in forum Vista Help
    Replies: 5
    Last Post: 30-01-2011, 02:30 AM
  4. Replies: 2
    Last Post: 01-06-2010, 04:00 AM
  5. Replies: 2
    Last Post: 25-12-2008, 03:01 PM

Tags for this Thread

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
  •  
Page generated in 1,652,993,965.56226 seconds with 16 queries