error 429: ActiveX component can't create object

G

GerryM

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top