ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   error 429: ActiveX component can't create object (https://www.excelbanter.com/excel-programming/313431-error-429-activex-component-cant-create-object.html)

GerryM October 13th 04 05:53 PM

error 429: ActiveX component can't create object
 
I'm trying to automate an Excel program using vbScript. I'm running WIndows
XP Prof. (SP2), Office 2003(SP1), WindowsScript 5.6, and VB6.0(SP6). The Set
oPP statement below gives Error 429:
Dim oApp
Set oApp = CreateObject("Excel.Sheet")

If this were VB, I would add a reference to the Object Library to the
project. What should I do in vbScript?


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com