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
[url]http://www.ITSYSSolutions.com[/url]


--
vibhub
------------------------------------------------------------------------
vibhub's Profile: [url]http://forums.techarena.in/members/vibhub.htm[/url]
View this thread: [url]http://forums.techarena.in/vista-help/1091912.htm[/url]

[url]http://forums.techarena.in[/url]

[url]http://support.microsoft.com/kb/292054[/url]





"vibhub" <vibhub.3kuyng@DoNotSpam.com> wrote in message
news:vibhub.3kuyng@DoNotSpam.com...[color=blue]
>
> 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
> [url]http://www.ITSYSSolutions.com[/url]
>
>
> --
> vibhub
> ------------------------------------------------------------------------
> vibhub's Profile: [url]http://forums.techarena.in/members/vibhub.htm[/url]
> View this thread: [url]http://forums.techarena.in/vista-help/1091912.htm[/url]
>
> [url]http://forums.techarena.in[/url]
>[/color]

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

Thanks & Regards,

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


--
vibhub
------------------------------------------------------------------------
vibhub's Profile: [url]http://forums.techarena.in/members/vibhub.htm[/url]
View this thread: [url]http://forums.techarena.in/vista-help/1091912.htm[/url]

[url]http://forums.techarena.in[/url]