Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 30th 04, 05:51 PM posted to microsoft.public.win32.programmer.ole,microsoft.public.access.activexcontrol,microsoft.public.dotnet.general,microsoft.public.excel.interopoledde,microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 1
Default Runtime error '429': ActiveX component can't create object. HELP!!

Hi. Let me explain the setup. I am using Visual Studio .NET to develop a sort of add-in (COM class) for Excel called SQLAddin. It basically queries a SQL server and pulls in data. Now within my Visual Studio Project, the SQLAddin references a compiled COM object built with Visual Studio 6.0 called SQLOld.dll. When I complie the project I get the following files in my \bin directory
SQLAddin.dl
SQLAddin.pd
SQLAddin.tl
Interop.SQLOld.dl

Within Visual Studio .NET I have set the project properties to "Register for COM Interop". The reason why I am mentioning the set up for the development for this project, is that this add-in works great on my computer. The VBA in Excel that accesses the object calls the functions correctly and correctly assigns the return values. BUT when I try to setup and run this Addin on another computer, it does not work. I get the error: Runtime error '429': ActiveX component can't create object. Let me explain my installation procedures for the other computer

To note, the computers I am installing the addin on all have the .NET Framework installed
First I copy over all the files in the \bin directory (as mentioned above) PLUS the actual SQLOld.dll. I also include the Excel file with the references and VBA code complied

So, if I go into Excel run the addin. I get the error. So then I think that perhaps the SQLOld.dll needs to be registered. So I run regsvr32 on the SQLOld.dll. The register succeeds, but when I run the addin again. I get the same error

So why does the addin work on my computer but not anyones else's? My hypothesis is that Visual Studio .NET is doing something behind the scenes when I compile. And I am not doing that on the other machine

Any ideas?

Thanks for you help

  #2   Report Post  
Old January 30th 04, 06:37 PM posted to microsoft.public.win32.programmer.ole,microsoft.public.access.activexcontrol,microsoft.public.dotnet.general,microsoft.public.excel.interopoledde,microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 1
Default Runtime error '429': ActiveX component can't create object. HELP!!

Try running depends.exe on your DLLs to check if you need
to redistribute other DLLs as well.

--
=====================================
Alexander Nickolov
Microsoft MVP [VC], MCSD
email:
MVP VC FAQ:
http://www.mvps.org/vcfaq
=====================================

"brazilnut" wrote in message ...
Hi. Let me explain the setup. I am using Visual Studio .NET to develop a sort of add-in (COM class) for Excel called SQLAddin. It basically queries a SQL server and pulls in data. Now within my Visual Studio Project, the SQLAddin references a compiled COM object built with Visual Studio 6.0 called SQLOld.dll. When I complie the project I get the following files in my \bin directory:
SQLAddin.dll
SQLAddin.pdb
SQLAddin.tlb
Interop.SQLOld.dll

Within Visual Studio .NET I have set the project properties to "Register for COM Interop". The reason why I am mentioning the set up for the development for this project, is that this add-in works great on my computer. The VBA in Excel that accesses the object calls the functions correctly and correctly assigns the return values. BUT when I try to setup and run this Addin on another computer, it does not work. I get the error: Runtime error '429': ActiveX component can't create object. Let me explain my installation procedures for the other computer:

To note, the computers I am installing the addin on all have the .NET Framework installed.
First I copy over all the files in the \bin directory (as mentioned above) PLUS the actual SQLOld.dll. I also include the Excel file with the references and VBA code complied.

So, if I go into Excel run the addin. I get the error. So then I think that perhaps the SQLOld.dll needs to be registered. So I run regsvr32 on the SQLOld.dll. The register succeeds, but when I run the addin again. I get the same error.

So why does the addin work on my computer but not anyones else's? My hypothesis is that Visual Studio .NET is doing something behind the scenes when I compile. And I am not doing that on the other machine.

Any ideas??

Thanks for you help

  #3   Report Post  
Old January 30th 04, 10:47 PM posted to microsoft.public.win32.programmer.ole,microsoft.public.access.activexcontrol,microsoft.public.dotnet.general,microsoft.public.excel.interopoledde,microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 1
Default Runtime error '429': ActiveX component can't create object. HELP!!

You still need to register the actual COM dll (SQLOld.dll) on user's
computer, using "regsvr32.exe" that is: click Start-Run and enter
"regsvr32C:\mypath\SQLOld.dll".

"brazilnut" wrote in message
...
Hi. Let me explain the setup. I am using Visual Studio .NET to develop a

sort of add-in (COM class) for Excel called SQLAddin. It basically queries a
SQL server and pulls in data. Now within my Visual Studio Project, the
SQLAddin references a compiled COM object built with Visual Studio 6.0
called SQLOld.dll. When I complie the project I get the following files in
my \bin directory:
SQLAddin.dll
SQLAddin.pdb
SQLAddin.tlb
Interop.SQLOld.dll

Within Visual Studio .NET I have set the project properties to "Register

for COM Interop". The reason why I am mentioning the set up for the
development for this project, is that this add-in works great on my
computer. The VBA in Excel that accesses the object calls the functions
correctly and correctly assigns the return values. BUT when I try to setup
and run this Addin on another computer, it does not work. I get the error:
Runtime error '429': ActiveX component can't create object. Let me explain
my installation procedures for the other computer:

To note, the computers I am installing the addin on all have the .NET

Framework installed.
First I copy over all the files in the \bin directory (as mentioned above)

PLUS the actual SQLOld.dll. I also include the Excel file with the
references and VBA code complied.

So, if I go into Excel run the addin. I get the error. So then I think

that perhaps the SQLOld.dll needs to be registered. So I run regsvr32 on the
SQLOld.dll. The register succeeds, but when I run the addin again. I get the
same error.

So why does the addin work on my computer but not anyones else's? My

hypothesis is that Visual Studio .NET is doing something behind the scenes
when I compile. And I am not doing that on the other machine.

Any ideas??

Thanks for you help





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL Runtime error '429' -- help please XL Baby Excel Discussion (Misc queries) 0 July 30th 08 09:20 PM
Activex component can't create object Naveen New Users to Excel 1 September 4th 07 02:57 PM
ActiveX Component Can't create object - Any Explainations? gopalan Excel Programming 0 January 5th 04 03:25 PM
DsoFile ActiveX component can't create object on other computers Jeremy Gollehon[_2_] Excel Programming 1 August 18th 03 09:44 PM
activex component can't create object with SAP 6.20 Mark Bigelow Excel Programming 0 July 22nd 03 06:24 PM


All times are GMT +1. The time now is 09:10 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017