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
Bookmarks