Solved

ActiveX component can't create object

Posted on 1998-08-21
15
233 Views
Last Modified: 2010-04-30
I have a Standard Exe VB program and am trying to activate Excel. I have defined appexcel as object. When I do "Set AppExcel = New Excel.Application", I get err-code 429 and the message "ActiveX component can't create object". The program is a standard EXE, not an ActiveX component. I re-installed XL, but no luck. I AM able to activate Word, but not Excel. I've done this before in other programs and have no idea why I can't do it in this program. Naturally, I have a deadline for this of Monday so any help is greatly appreciated.
0
Comment
Question by:chucka
  • 9
  • 5
15 Comments
 
LVL 6

Expert Comment

by:anthonyc
ID: 1430275
Do you have the Excel object library referenced in your project?

dim xlCur as excel.application
set xlCur = new excel.application  

This should work if you have the object library marked as a reference in your project.
0
 

Author Comment

by:chucka
ID: 1430276
I'm sorry, I should have mentioned that - Yes, I have set the reference to the Excel Object library.
0
 

Author Comment

by:chucka
ID: 1430277
I have already set the freference to the Excel Object Library. I should have mentioned that.
0
 
LVL 6

Expert Comment

by:anthonyc
ID: 1430278
Can you build an existing XL file, and use getobject to open it?  This doesn't fix your problem, but I am curious if you could do this

dim xlCur as excel.application
set xlCur = getobject("c:\path\to\xl.xls")

and make it work
0
 

Author Comment

by:chucka
ID: 1430279
Nope, err=432, "File name or class name not found during automation operation."
0
 
LVL 6

Expert Comment

by:anthonyc
ID: 1430280
well assuming you placed an excel file where you said it was and it did not open..... then I don't know what to say.. sounds ike the excel library needs to be registered....
0
 

Author Comment

by:chucka
ID: 1430281
Agreed. That's why I reinstalled XL. Am I missing something here? ie. Is there a way to register it other than a reinstall? I am goint to try it on my machine at home tonight. Just FYI, I'll let you know what happens there.
Thanks for the help.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Accepted Solution

by:
danshu earned 50 total points
ID: 1430282
I have met the same prolem. I can not create any object of Excel unless Excel is already running. So, try to run Excel first, then run your program.

That is not a good solution. Anyway wish it will do a little help for you. Good luck.  
0
 

Author Comment

by:chucka
ID: 1430283
OK, but I'll have to try it on Monday. It works fine on my machine at the house. However, your answer brings up an interesting observation. I also CANNOT activate Access by trying to activate a database. I have to first start Access and then open the database. I'll bet there's a relationship to these 2 problems. On Monday I'll try starting XL first. If that works, I can at least test at the office. I'll let you know.

Thanks
0
 
LVL 6

Expert Comment

by:anthonyc
ID: 1430284
Something is wrong.  I can use CreateObject and start up excel without ANY problems.

if I do this (with excel NOT running, and a reference to Excel 8.0 in my object refs)

dim x as new excel.application


Excel opens... invisible, until I set the visible prop = true
0
 

Author Comment

by:chucka
ID: 1430285
I've tried to do it with XL running (err.number is 429). I also tried defining it as new Excel.application and I get the same thing. I have no problems running this at home. Both machines are configured nearly the same.
0
 

Author Comment

by:chucka
ID: 1430286
This is getting even more annoying. When I build a setup file for it, all goes well, except that when I do an install and then run the app (on a different machine), there is NOTHING on the form. No labels, no controls, etc.....

I've done this several times before with other apps with no problem.
0
 

Author Comment

by:chucka
ID: 1430287
Scratch my last comment. This XL thing has got me so flustered, I forgot to recompile the app before I built setup. At least that part works and as long as I install on a machine othert than my own, the XL stuff works too. The big problem is that I develop on THIS machine.
0
 
LVL 6

Expert Comment

by:anthonyc
ID: 1430288
Look in your registry under

\\hkey_classes_root\excel.application\

and make sure the class ID is:
{00024500-0000-0000-C000-000000000046}


Check the same in

\\hkey_local_machine\software\classes\excel.application
0
 

Author Comment

by:chucka
ID: 1430289
Yep, it's the same in both reg keys.

0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now