The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Can't create object error with Excel VBA
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

peter.cook

UK
356 Posts

Posted - 09/16/2005 :  12:31:57 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): 7.5 SR5
Operating System: Win 2000

Hi,

Trying to launch an instance of Origin with Excel 2000 and I keep getting the error :

Runtime error: '429'
ActiveX compnent can't create object.

This occurs both with my code and the sample code provided (ie it's not down to my code).

Any ideas?

Thanks,

Cheers,

Pete

easwar

USA
1964 Posts

Posted - 09/16/2005 :  2:01:00 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Pete,

We found the following Microsoft Support web page:
http://support.microsoft.com/?id=828550

Does the problem pertain to just one machine or other machines as well? There could be a problem with the Origin installation on this machine. Could you run Origin manually on this machine and it works fine?

Easwar
OriginLab

Go to Top of Page

peter.cook

UK
356 Posts

Posted - 09/19/2005 :  08:26:28 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Easwar,

Thanks for the reply.

I still don't know / understand why the problem occurred but the link was helpful in that it prompted me to change the path in the registry for origin.application to our client C:\origin 7.5\Origin75.exe rather than the current OriginPro path C:\Program Files\Origin75\Origin75.exe.

The GetObject("","Origin.Appliaction") now works.

Previously, GetObject("","Origin.ApplicationSI") did work (with an existing instance of Origin.

My PC does differ from others in that I have had various versions & builds installed at different times.

Practically this is not a problem in that all our users have 7.5 Client but if you have any further insight in light of the above please let me know.

Thanks,

Cheers,

Pete




Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000