Visual Basic :: Use COM Object From Excel VBA - Made In .NET "ActiveX Component Can't Create Object"

Use COM Object From Excel VBA - Made In .NET "ActiveX Component Can't Create Object"
I am going to outline the steps I go through to produce the problem. Hopefully this will help you understand the problem better.

I have created a simple COM DLL in .NET by using the COM class template and by setting output to a type library (DLL). All the object does is return a string value. At this point I have not checked the option to register for COM interop in Visual Studio.

So I go into Excel (where I want to use the object). Go to VB Editor and Tools -> References and to Add Reference. I browse until I find the in directory of the project. Select the .dll file outputted by the program. Then click open -> I get the message "Can't add reference to the specified file." So here is my first question: Why not?

So then I go to my project in Visual Studio. Highlight the project -> click properties ->go to Build -> and check "Register for COM interop" -> then I rebuild my solution. After this build there is another file in the in directory with the same name as the .dll but has the extension .tlb (Type Library).

So I go back into Excel. Go to VB Editor -> Tools -> References and to Add Reference. I browse until I find the in directory of the project. This time however I select the .tlb file outputted by the program. Then click open -> I don’t get an error message so this is good. So here is my second question: Why does the .tlb work and not the .dll at this point?

Now after this step. I create the object in VBA code. Compile and run the macro and sure enough it returns the string and puts in the right cell. Great! But wait. Now many more people need this object to work with Excel.

So I copy the Excel Workbook and everything in the in directory from my project to another person’s computer. Then I open the Excel workbook -> then to VB Editor -> References to double check the path to the .tlb file -> (then compile and save for peace of mind). But here is the big problem... when I run the macro on another person's computer I get the message "ActiveX component can't create object." And I get this at the line where I say: Set testObj = New Object.

My ideas... could it be that I am an Admin on my PC but not the other? If so, how do I get around this. Or is Visual Studio doing an extra step in the compile/build process that I’m not replicating on the other PC? Does it need to be an global assembly?

Also, .NET is installed on the other PC and I have tried to register the .DLL, but this is unsuccessful as well? I guess that is another question: why?

If someone could help me out here I would be very grateful. I have been trying to figure out a solution for a long time. I just don’t understand why everything works fine on my PC but won't run on another.

Thanks for being patient.
brazilnut

Vb6 Com+ Object Runs Once Then Errors With "activex Component Can't Create Object"
I have a vb6 com object that will run once successfully, then error with "activex component can't create object" on the call to the com object (see below, GetAppt.GetHRoomsAppointments). the com object (activex.dll) runs in com+ on a win2003 server. The project is set to run unattended, retain in memory, apartment threaded.

The com reads room numbers from oracle 9.2 client (via ado), then reads from outlook 2003 the rooms' appointments (cdo 1.21, outlook 11.0 object library references), and then writes the appointments back out to oracle (via ado). I have it running under com+ (in component services) using an administrator id (as identity) and activation as Server Application. I call the com object from a vb6 .exe.

If I run the code in vb6 debug mode, it works successfully on multiple runs. But once I compile into a .dll, add it to com+, and call from an .exe, it runs once. If I reboot the server, it will run successfully once. I was thinking I was leaving an object open but can not find it. I am doing close on recordsets, ado connections, and setting them to nothing.

How the code works is for each room, it will read from outlook, open an oracle recordset, add to the recordset, and then close the recordset.

Any ideas? I can send .dll code if need be. the .exe is below.
Is there a way to programmatically clean out the com object in the .exe besides setting it to Nothing?

Option Explicit
Sub Main()
Dim GetAppt As Object

Set GetAppt = New GetHRoomsAppts.clsGetHRoomsAppts
GetAppt.ProvID = "1234"
GetAppt.ProvName = "John Doe"
GetAppt.MailBoxServer = "xxx.abc.com"
GetAppt.eduDataBase = "ora.path.com"
GetAppt.apptFolderDir = "Public Folders/All Public Folders/Dept/SUN/Calendars/"
GetAppt.apptTableDir = "fileLoc.Appts"

GetAppt.GetHRoomsAppointments
Set GetAppt = Nothing

End Sub

"Runtime Error-429 ActiveX Component Can't Create Object". For COM+ Component On Windows2003
"Runtime Error-429 ActiveX Component can't create Object". for COM+ component on Windows2003 ...?

Debugging For: "ActiveX Component Can't Create Object Error Number: 429"
After successfully logging into client software I receive the error "ActiveX component can't create object Error Number: 429"

I looked at the registry keys that are being called and all the ones with "activex" in the path or title are called successfully.

Where do I start to debug this error?

Help is greatly appreciated.
Thank you.

"Run-time Error '429' ActiveX Component Can't Create Object"
Hello,

I developed my app on a laptop with Windows XP Home. It runs fine. On an earlier version, it ran fine when I installed in on my Windows 2000 desktop. Now, for some reason I get a "Run-time error '429' ActiveX component can't create object" message (see attached image).

I am not using a database. I am using a dll and am registering it using INNO 5 installer. I have manually registered it also, but still get the same Run-time error.

Inno line to register....

Source: "C:Documents and SettingsuserDesktopInstallTools.dll"; DestDir: "{sys}"; Flags: restartreplace sharedfile regserver

The only thing I can remember changing is that I added a picture to my "About" form.

Thoughts?

Runtime Error 429 "ActiveX Component Can't Create Object"
With my chat program, when i clicked "Connect" on one side, error popups saying "Runtime-Error 429 ActiveX Component Can't Create Object"
What should i do???
What should i do?
what caused this error and how do i fix it???
I really need to get my program workin

pls help

thank you!

Run-time Error 429 "ActiveX Component Can't Create Object"
Hi all,

I made a connection to Rational Rose dll in visual basic. In my computer everything works but if I use package&deployment wizard to make run the .exe in another computer it appears the runtime error 429, ActiveX component can't create object?

In target machine I have already installed visual basic runtime environment.

Are there any dll I have to add to the target machine besides dll that have been added by package&deployment wizard?

Sorry for my poor english.

Runtime Error: 429 "ActiveX Component Can't Create Object"
This error is driving me insane.

I ran the fix from msdn, no luck.

My programs run perfect on my computer, and if i send my friend the source, he can run it fine in vb.

Problem is, when i compile them, the only one who can run them, is me!

I thought it had to do with the activex controls microsoft stated in the msdn article.. so deleted every reference to them in my project, no luck.

I started over, Compiling step by step, figuring out whats wrong...

I didn't get passed step 1!

Ok now onto my problem...

I have a Project group, with a standard exe, and a activex dll.
In the dll i have a class file, so i can open up forms, when the exe tells the class to open it, it gives a runtime 429 error, saying "activex compontent can't create object" what does that mean, and how can i fix it?

"Runtime Error-429 ActiveX Component Can't Create Object". For COM+ Comp. On Win2003
Hi There!

Could anybody please help regarding the below issue.

We had a COM+ component deployed on Windows 2000/NT machine it was working fine, I mean when it was being invoked from other machines it was creating object and was serving the purpose.

Recently as an upgrade we moved all the COM+ component from Windows 2000/NT to WINDOWS 2003 and now when we are trying to invoke that component its throwing "Runtime Error-429 ActiveX Component can't create Object".

Client side machines are running Windows XP with SP2, COM+ component was created as a server application. I doubt that it may be because of Windows 2003 security issue but not sure or am I missing something while building that component.

Please help or provide your suggestions.

Thanks in advance.

CreateObject("Outlook.Application") - Error 429 ActiveX Component Can't Create Object
I'm trying to learn how to program with Outlook Express 6 using Visual Basic 5. The problem is with having these couple lines of code:

Option Explicit

Dim Outlook As Object

Sub Main()

Set Outlook = CreateObject("Outlook.Application")

End Sub

I get a Runtime Error 429: ActiveX Component Can't Create Object. Of course obviously my Outlook Express works fine. I've done some heavy duty research on how to solve this problem looking literally everywhere on the internet. Registering the MSIMN.EXE using DOS was one of the solutions. It didn't work. The registry looks like it might be the solution. Over in this key path (HKEY_CLASSES_ROOTCLSID{0006F03A-0000-0000-C000-000000000046}) where Outlook Express is supposed to be located, I noticed it was empty! It is supposed to have InprocHandler32, InprocServer32, LocalServer32, ProgID, Typelib, and VersionIndependentProgID. Both ProgID and VersionIndependentProgID are supposed to have "Outlook.Application" as a string value (REG_SZ) which is required for scripting when you want ActiveX components to create the object for you. I can try typing the values by hand which probably won't work but is there anything else I can use to automatically fill these registry values in without screwing up Outlook Express 6? Possibly a program that registers it and fills in the registry keys for me?

Also, if you don't have the exact solution, I would at least like to know what value you have under HKEY_CLASSES_ROOTCLSID{0006F03A-0000-0000-C000-000000000046}InprocServer32 since the other computer in my house (which isn't mine) has a value of some dll from McAfee, and McAfee is what I don't have.

"ActiveX Component Can't Create Object" Error
People that install my program all get this "ActiveX component can't create object" error. I am pretty sure it's caused by the reference "Microsoft Ooutlook 10.0 object library" (msoutl.olb).

Do I need a liscense or something to distribute this? How can I fix the error?

Thanks

"ActiveX Component Can't Create Object" Error
I am trying to access Outlook Express's address book with some code I found on one of the forums here. The CreateObject function in that code however produces a "ActiveX component can't create object" error (error code 429) when executed.

When I try my own code I get the same error. The code:

Code:
Dim Outlook As Object
Set Outlook = CreateObject("outlook.application")

Which files need to be installed and which version of Outlook Express do I need? (I am using Outlook Express 6) Also, I can't find a reference to outlook.application in the registry which as I understand must be some where in the registry for CreateObject to work. Which files if any do I need to register and how?

BTW:
I searched the internet and the forums here before posting.
And:
When I replace "outlook.application" with "excel.application" for example, just to test the CreateObject function I get no errors.

The code I found on these forums can be found in this thread: http://vbforums.com/showthread.php?s=&threadid=292503

WMI Failure - "ActiveX Component Can't Create Object"
i run this code because I need a list of printers from a windows 2000 AS.

But on two of my boxes I recieve "ActiveX component can't create object"

Can this be fixed?

Code:
Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\" & strComputer & "
ootcimv2")
Set colInstalledPrinters = objWMIService.ExecQuery("Select * from Win32_PrinterConfiguration")

Error 429 "ActiveX Component Can't Create Object" ???
Hope someone can help - this is doing my head in!

(Dev Env: Win98 VB6.0 SP3)

Ok - I've got an app that works fine on the win98 development machine. When installing on win95 test machine it works ok until suddenly it throws up this Error 429 "ActiveX Component Can't Creat Object"

I'm really new at this and don't know how to debug it... From what I know:

It's the msInet control that's doing it, BUT - it's already successfully executed a couple of commands:

1. "CD /" (to test the ftp connection)
2. "CD /website/test/" (to change to the required directory to transfer to)

The one that fails is a PUT command...??

PLEASE help - I've got a few other bugs in the software which I expected, but this is the one that is really stumping me!

Cheers all,

------------------
Chris Keeble
www.giglist.com
mailto:chris.keeble@giglist.com

Big Problem With "activeX Component Cant Create Object" #429
Hi Guys

Im acutaly working on a Mediacenter-Application. It always ran on all my computers, till i did include a new configfile-structure. On my work-pc everything works fine. But on my Notebook the Error 429 "ActiveX Component cant create object" appears. So i switched back to the old configfile structure. The Error seems to occur directly on startup of the software, so i can only guess where the problem is. The only OCX I use is mci32.ocx. For testing purposes is removed the activex components completely but the error still happens. Im going to drive crazy. Its a really BIG program. I work for it nearly a year. I have been working on this error for days, read every thread on this topic, but nothing could help me.
Here some Details...

I think the error must happen in one of these 2 Functions

Declare Function GetPrivateProfileString Lib "Kernel32" Alias "GetPrivateProfileStringA" (ByVal lpApplicationName As String, ByVal lpKeyName As Any, ByVal lpDefault As String, ByVal lpReturnedString As String, ByVal nSize As Integer, ByVal lpFileName As String) As Integer

Function Getini(ByVal INIFile As String, ByVal Section As String, ByVal Key As String)

Dim RetVal As String, Worked As Integer
RetVal = String$(255, 0)
Worked = GetPrivateProfileString(Section, Key, "", RetVal, Len(RetVal), INIFile)

If Worked = 0 Then
Getini = ""
Else
Getini = Left(RetVal, InStr(RetVal, Chr(0)) - 1)
End If

End Function

OR HERE:

Public Function GetWinDirectory() As String
Temp = Environ("windir")
If Right(Temp, 1) = "" Then Temp = Left(Temp, Len(Temp) - 1)
GetWinDirectory = Temp
End Function

This is the first part of the Form_Load sub. Here has to be the error!

Randomize Online = True
A = Right(Now, 8)
lastkey = Int(Right(A, 2)) + (Int(Mid(A, 4, 2)) * 60) + (Int(Left(A, 2)) * 60 * 60)
Themestatus = 1
Dim mixstat As Long
Mutestat = False
mixstat = OpenMixer(0)
Indizierung = False
tastdruck = False
ButtCH = True
WindowsDir = GetWinDirectory
IniPath = WindowsDir + "SARSMediacenter.ini"
'Lese Haupteinstellungen
progpath = Getini(IniPath, "Main", "Programmverzeichniss")

After the last line, no more code is executed and the error occurs.

Please Help me.

Thx Max

PS: I Am Working with VB5:-)

"ActiveX Component Can Not Create Object" Error
Hi, all...
I have completed my project and used P&D Wizard to create a setup.exe package of the program.

I tried to install the application in other PCs and meet some problems. All the PCs i have tried to installed the application are using Win2000, i also developed the tool in Win2000.

The error message is "ActiveX component can not create the object" in the procedure of registering DLLs during installation of the application.

I only met this problem in some PCs not all of them. However all the PCs are using Win2000.

My program is quiet simple, i added some new components such as CommonDialog box, progressing bar. Since i need to generate a word document, so added a new reference Microsoft Word 9.0 object library. And some simple APIs also used in my program.

Any idea on this ???

Sami.

P.S>

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

This is the [Bootstrap Files] in my SETUP LST File

[Bootstrap Files]
File1=@VB6STKIT.DLL,$(WinSysPathSysFile),,,3/26/99 12:00:00 AM,101888,6.0.84.50
File2=@COMCAT.DLL,$(WinSysPathSysFile),$(DLLSelfRegister),,5/31/98 12:00:00 AM,22288,4.71.1460.1
File3=@stdole2.tlb,$(WinSysPathSysFile),$(TLBRegister),,10/10/02 10:10:10 AM,17920,3.50.5014.0
File4=@asycfilt.dll,$(WinSysPathSysFile),,,10/10/02 10:10:10 AM,77824,3.50.5014.0
File5=@olepro32.dll,$(WinSysPathSysFile),$(DLLSelfRegister),,10/10/02 10:10:10 AM,106496,5.0.5014.0
File6=@oleaut32.dll,$(WinSysPathSysFile),$(DLLSelfRegister),,10/10/02 10:10:10 AM,569344,3.50.5016.0
File7=@msvbvm60.dll,$(WinSysPathSysFile),$(DLLSelfRegister),,10/10/02 10:10:10 AM,1388544,6.0.92.37

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

"ActiveX Component Can't Create Object"
I'm using AutoCAD with the software I'm writing in VB 6.0, and I need to use late binding because I don't know what version of Autocad will be on the user's computer. (When us reference the Autocad type library, you have to specify version). The trouble is I get the error "ActiveX component can't create object" Error #429 when I try to run the software on another computer with the same version of Autocad (2004) using late binding. The strange thing is, it works fine on this computer... I need this software to work problem-free when it is installed on another computer with Autocad.

Thanks, any help is welcome

DTS "ActiveX Component Can't Create Object"
Hello,

First time to include DTS Execution Module in a Visual Basic application. It runs well in my pc. However, I'm encountering errors such as "ActiveX component can't create object" in other pcs which has no SQL Server Installed. I've already checked dtspkg.dll, dtspump.dll and custtask.dll in the References yet without any luck, error still occurs.

Help!

Why Can't Create "Excel.Application" Object Using "CreateObject" Function
Hi there,
I try to create an "Excel.Application" object using CreateObject function, I got "nothing" from the return variable without any error messages, but It works well on another machine that it has same environment settings(include same references setting) on those 2 machine: Win2k/Sp4, VB6/Sp5, Mdac_type2.7, the following is source code snippet:

Public appWorld As Excel.Application
Public wbWorld As Excel.Workbook
Sub Setup()
On Error Resume Next 'ignore errors
Set appWorld = GetObject(, "Excel.Application")
If Err.Number <> 0 Then
Set appWorld = CreateObject("Excel.Application") 'run it
End If
Err.Clear
End Sub

I got "nothing" from "appWorld", even I remark all of error handle lines, the same result I got, pls help,thanks!
ps: you could reply me to : frankie@sompojapan.com.hk

Vbsendmail.dll Access 2003 "Active X Component Can't Create Object"
Hello. I have been using vbsendmail.dll (I have the latest version of this file as well) in my Access 2000 VB Module for years and it works great. I have a scheduled task that runs every morning and sends out about 20 different emails using the smtphost. We have upgraded to Access 2003. When the module starts to run the "Active X Component Can't Create Object" pops up. I have gone thru all the help regarding this error. When I try to use Regsrv32 there is an error: DllRegisterServer in C:windowssystemvbsendmail.dll failed. Return Code is 0x80004005. Any help on this would be greatly appreciated. I just like the way this ran with no problem for so long and it would be ashame to have to go to something else but I am open to suggestions as well. Thanks!

Pocket PC 2000 Emulator: ActiveX "Can't Create Object" Bug (Q260150)
I am unable to run ANY projects which use controls other than the default, basic ones such as textbox, commandbutton, etc. From what I gather, its a bug (260150) in which unused ActiveX components are "unregistered." Can anyone help?

Method "SaveAs" Or "Save" Of Object "Excel.Workbook" Does Not Work.
Hi people.
I did for a long time a program that uses excel automation, so that from a template will create a final file with some data pulled from the database (with ADO). At the end and when the Excel file is ready to be saved I got in a couple of computers some problems. In the whole LAN have XP, but in these 2 computers we have SP2. I have checked the rights and are OK (I have even tried to save the Workbook under the Temp folder and also the same problem).
Working with Office 2003 (SP1).
I have searched in internet about any bugs but I don´t find anything.
Any ideas.
Thanks for your time
Jaime

ActiveX Component Can't Create Object Or Return Reference To This Object (Error 429)
MSDN talks about the "registry" and "setup program". I'm a beginner and CLUELESS! I tried to install Active X references and got the following notice: Name conflicts with existing module, project, or object library. The last line is where I get the run-time error in VB6:

Dim ppApp As PowerPoint.Application
Dim ppPres As PowerPoint.Presentation
Dim ppShape As PowerPoint.Shape
Dim ppCurrentSlide As PowerPoint.Slide
Dim msoTrue As New OLEObject
Dim msoFalse As New OLEObject
Dim oPicture As New OLEObject

Set ppApp = CreateObject("PowerPoint.Application")
ppApp.Visible = True

Set ppPres = ppApp.Presentations.Add(msoTrue)

Hope someone can help me....thanks Warren

Please Help On "Can't Create ActiveX Component" Error.
I have a program published on the internet that runs perfectly on my machine. I have included all the dll and ocx files with the Inno setup and have a program that rigisters all these ActiveX components.

However, when it is installed from the net, it still gives the Can't Create ActiveX component error!!

What am I doing wrong??

ANY HELP would be appreciated.

Thanks

ActiveX Can't Creat The Object ("mapi.session")
Hi ppl,
i'm having a problem that consistes on this:

i'm tring to receive an email using mapi
and then pass is body to sql db...
i have worked on a xp machine with vb6 and MSEchange server ...
every thing worked all right but know i need it to run in a w98...
the problem is i have a run time error "ActiveX can't create the object"
i have created a new project in w98 like the other one and it keeps given me the same error...
i have already instaled dcom98 and mdac..
i is still the same!

this is my code:

Public Function mailtobd()
Dim objsession As MAPI.Session
Dim objmessage As MAPI.Message
Dim objFolder As MAPI.Folder
Dim objfolders As MAPI.Folders
Dim readedfolder As MAPI.Folder
Dim errorfolder As MAPI.Folder
Dim objInbox As MAPI.Folder
Dim collInMessages As MAPI.Messages
Dim lJaExiste As Boolean
Dim lJaExiste2 As Boolean
Dim x As MAPI.Message
Dim n As Integer

lJaExiste = False
lJaExiste2 = False

Set objsession = CreateObject("mapi.session")'HERE IS THE_ ERROR
    objsession.Logon profilename:="outlook"

Set objFolder = objsession.GetDefaultFolder(1)
Set objfolders = objFolder.Folders
If objfolders.Count > 0 Then
    For n = 1 To objfolders.Count
        If objfolders(n).Name = "readedmails" Then
           lJaExiste = True
           Set readedfolder = objfolders(n)

        ElseIf objfolders(n).Name = "errormails" Then
            lJaExiste2 = True
            Set errorfolder = objfolders(n)
        End If
    Next n
End If

If lJaExiste = False Then
   Set readedfolder = objfolders.Add("readedmails")
End If
If lJaExiste2 = False Then
   Set errorfolder = objfolders.Add("errormails")
End If

Set collInMessages = objFolder.Messages
Set objmessage = collInMessages.GetLast

While Not objmessage Is Nothing

    If StrComp(Trim(objmessage.Subject), Trim("SALSAGAMELOJA"), vbTextCompare) = 0 Then
        If tratamail(objmessage.Text) = True Then
            Set x = objmessage.MoveTo(readedfolder.ID)
        Else
            Set x = objmessage.MoveTo(errorfolder.ID)
        End If
    End If

    Set objmessage = collInMessages.GetPrevious

Wend


objsession.Logoff
Unload Form1
End Function

My head is spppppiiiiininnngggg what should i do?!? ;)

ADO Command Object Returns A "Method 'Execute' Of Object '_Connection' Failed" Error
Hi you all,
I have a VB6 app using an Access XP back end.
I Use a function which returns a Read Only, Disconnected ADO Recordset (used to populate lists, combos etc. using minimal resources).
I use it all the time without a hitch.
It started returning a "Method 'Execute' of object '_Connection' failed" error called with a SQL which works just fine when it's used as a query in the Access DB.
Why should the Execute method fail if the SQL works well in Access' Query design window?
Any help will be highly appreciated.
Thanx!
Guy

The function is:
Function GetDisconnectedRS(ByVal sSQL As String) As ADODB.Recordset
Dim adoRS As New ADODB.Recordset
Dim ucmdGetDisconnectedRS As ADODB.Command

Set ucmdGetDisconnectedRS = New ADODB.Command
With ucmdGetDisconnectedRS
.ActiveConnection = oConnect.ConnnectionObject
.CommandType = adCmdText
.CommandText = sSQL

Set adoRS = .Execute()

End With

Set adoRS.ActiveConnection = Nothing
Set GetDisconnectedRS = adoRS

SQL:
SELECT at.ActualTestID, at.PatientID, at.TestID, at.atDate, t.testDescription, p.patFirstName, p.patSurname
FROM (tblActualTests at INNER JOIN tblTests t ON at.TestID = t.TestID) INNER JOIN tblPatients p ON at.PatientID = p.PatientID WHERE at.atDate BETWEEN #02/08/2007# AND #02/08/2007# AND Not atDone
ORDER BY at.atDate DESC, at.TestID, p.patSurname

Just a note: The function works fine few code statements before it fails, with SQLs such as "SELECT DISTINCT patFirstName FROM tblPatients ORDER BY patFirstName".
I've tryed to run "SELECT * FROM tblActualTests" and it does work but hey, what's wrong with a few Joins?
And besides which the function didn't fail me in the past with much more complex SQLs.

Thanx,
Guy

ActiveX Component Can't Create Object
I need help troubleshooting my application.

I did the developing on VB6/Windows 2000 and SQL Server 7. The application uses some objects from a couple of DLLs that were developed in-house - I do not have the source code for these and made no changes.

I packaged everything up using the P&D Wizard, including all of the referenced DLLs. (I also included MDAC 2.7 - this was necessary to correct an Error 429 - Class Does Not Support Automation). I have tested it on a few machines running 2000 and NT4 and everything works fine. However, I tested it on a clean-ish Win95 machine and got the error (see title of message). The application loads and runs as normal until the user tries to use a part that uses one of the custom dlls in particular.

I have looked for the dll in question and confirmed that it was installed and registered correctly. I have also confirmed that the version is the same as the one in the package and the one I have on my computer. In fact the first time I checked there were different versions, but I corrected the problem, re-packaged and re-installed and still no change.

I installed DCOM 1.3 (for Win95) prior to installing my app because I heard it was necessary for MDAC. Doesn't seem to have made a difference. I have confirmed that MDAC updated to 2.7 successfully.

Binary Compatibility is set.

I can't think of anything else to try - what could be the problem??

Thanks for your help.

Help - Activex Component Cant Create Object
Hi,
Im having trouble with crystal reports when distributing a VB app where the reports are built at run-time. This works on one users Pc but not on another. I initially got the error 'cannot locate database dll ' so installed ntwdblib.dll ad this has now gone but i get the above error instead.

any help gratefully recieved, Sue

ActiveX Component Can't Create Object
I am using VB 5.0 and have an installation/configuration problem I belive.
I had this working on my other computer and have been trying to find what
the different configuration is but can only see that msflexgrid and ms comm
dlg is (SP3) on the computer where it doesnt work and on the other it
says only msflexgrd and ms comm dlg in the references. I do believe
there is something else that is missing but cannot figure out what.

I have this code

------------------------

Dim wstemp As Workspace

Set wstemp = DBEngine.Workspaces(0)

------------------------

and at the second row I get

Run-time error '429'

ActiveX Component can't create object

The help for this error doesn't help me.

What do I need to do?

ActiveX Component Can't Create Object
Hello all,

Firstly, I'm sorry if I'm not entirely up to scratch on VB - it's something that I've only recently had to involve myself in at work and so my familiarity is limited. I also have little or no access to supporting documentation and so on many occasions have been prone to asking stupid questions.

I have compiled an .EXE using VB 6.0 studio. I am running this on Windows 2000. The References in my VB project are as follows:

MSVBVM60.DLL
VB6.OLB
STDOLE2.TLB
CDAUTO.TLB (A library file to interface with a third party product, provided by the software supplier)

When compiled, the .EXE works fine on my own machine. However, even when packaged using the Deployment Wizard, it does not work correctly on other machines.

The code works fine until object types referenced in the CDAUTO file are created. I then get the following error message:

"ActiveX component can't create object"

There were no errors (improperly registered DLLs, etc) during the install process, so obviously something must be missing on the other machine that is already in place on my own. Does anyone have any ideas as to what I may need to do?

Miz.

429-ActiveX Component Can't Create Object
I've written a VB6 front end with an Access 97 back end.

The program uses MS ADO 2.5 to connect.

The application works fine on my development machine running XP, but I run into problems on the 98 machine I'm trying to use it on.

The install goes fine except it won't register mfc42.dll, crystl32.ocx, msado25.tlb, and craxdrt.dll.

If I ignore all these files then the program will run, except on the screens where I am accessing the database. On these screens I get the error

'429-ActiveX component can't create object'

I tried using the Depends.exe to find if I have a file out of date for the 4 files that won't register. Both Crystl32.ocx and Craxdrt.dll reference the mfc42.dll which isn't registering. The depends file shows that mfc42.dll (6.0.8665.0) needs several files of version 5.1.2600.0 (kernel32.dll, ntdll.dll, gdi32.dll, user32.dll, advapi32.dll, rpcrt4.dll). None of these are included in the package and deployment wizard and when I check their versions on the 98 machine it has mfc42.dll (6.0.8665.0) but all the other files are older versions (4.10.1998, etc).

The same with Crystl32.ocx - Depends.exe shows it needing files in teh 5.1-6.0 range, but the files on the machine are 4.1-5.8).

Are these files my problem or is it something else causing errors with opening the database? I don't feel very confident in including files like kernel32.dll in my install for fear of messing up something else on the machine. Do I need a service pack?

The machine I'm ultimately trying to install on is running 95, SP1.

THANKS for any suggestions.

jules

ActiveX Component Can't Create Object...
This runs fine on my XP machine, get this error on my Win98 machine... A Run-time error 429

Think it's happening in the Set

ActiveX Component Can't Create Object
Hey all i am trying to figure out what is causing the "ActiveX component can't create object" error in my program..

When i insert the USB thumb drive into the USB slot i get the error:

Code:
ActiveX component can't create object
1000429
0
429
Here is my code:

Code:
Private Sub SysInfo1_DeviceArrival(ByVal DeviceType As Long, ByVal DeviceID As Long, ByVal DeviceName As String, ByVal DeviceData As Long)
ButtonTimer.Enabled = True
End Sub

Private Sub SysInfo1_DeviceRemoveComplete(ByVal DeviceType As Long, ByVal DeviceID As Long, ByVal DeviceName As String, ByVal DeviceData As Long)
'ButtonTimer.Enabled = True
End Sub

Sub checkForUSB()
Dim FSO As New Scripting.FileSystemObject
Dim Drive As Scripting.Drive
On Error GoTo ERRR

For Each Drive In FSO.Drives
If Drive.IsReady Then
If Drive.VolumeName = "FISHBOWLUSB" Then
MsgBox Drive.DriveLetter & ":" & "FishBowlAdmin.exe"
End If
End If
Next

ERRR:
MsgBox Err.Description & vbCr & Err.HelpContext & vbCr & Err.LastDllError & vbCr & Err.Number & vbCr & Err.Source
End Sub
The error results in the CheckForUSB sub.

I've did the P&D wizard and installed all componets needed BUT it did not register the scrrun.dll. Could that be causing this error? If so, how in the world can i register it!!

PS> I'm using windows 98SE!

Thanks for your time,
David

ActiveX Component Can't Create Object
I am scratching my head on this one. I had to have my laptop replaced and when I try to create my object using the following code:

Code:
set outapp = CreateObject("Outlook.Application")
I get the error message 429 - ActiveX component can't create object. The funny thing is all this worked on my old laptop and it is supposedly imaged the same way.

Any idea of which ActiveX component needs registered? I cannot for the life of me find the dll or ocx in question. The Reference points Microsoft Outlook 11.0 Object Library with location c:program filesMicrosoft OfficeOffice11msoutlib.olb.

Thanks,

Anthony A. Fagan

ActiveX Component Can't Create Object
I cannot find this solution in the forums. I have an application that has an EXE and several com objects registered on a server. I am trying to add a new class to one of the objects and I am developing it in the IDE with all DLL's loaded in a project group. Up and till before adding the new class to one of the DLL's, things were OK. Now when I run it I get "ActiveX component can't create object" on trying to create an instance of the class:

Set gobjFUMan = CreateObject("ServerLib.clsFUManager", gstrServer)

(gstrServer is the name of the server where the comm object ServerLib is running)

I Know this has something to do with registering but I have tried all combinations of registering and unregistering etc.. but nothing has worked so far. Can anyone enlighten me?

Andy

RTE 429: ActiveX Component Can't Create Object?????
I am using vba for excel 2000 and am getting the error on the following line.
Set grph = CreateObject("graph.Application")

what i am trying to do is open microsoft graph.

any help?

ActiveX Component Can't Create Object
Hi all and thanks for taking the time to help me with this issue.
I sometimes get the error msg "ActiveX Component cannot create object" why does that come up and what can i do to solve it? knowing that the ocx i'm using is inside the same project as .CTL

thank you

ActiveX Component Can't Create Object
Hi everybody

i have a problem with ActiveX component can't create object
this is just a script to get some info about a computer
where the mistake is i put this in bold and underlined it

all suggestions are welcome

thanks in advance

Dim objUserName, objUserDomain, oGroup, objUser, gList, WshShell, sMessage, sTitle, objDomain, vDomain, vUserName, objChangePwdTrue, objChangePwd, objUserProfile, objPwdExpiresTrue, objFlags, objAcctDisabled, intPwdExpired, objPwdExpiredTrue

'domainname you have to fill in yourself just like the username
Set objUser = GetObject("WinNT://" & "domain-name" & "/" & "user-name" & "", user)

For Each oGroup In objUser.Groups
If gList = "" Then
gList = oGroup.Name
Else
gList = gList & ", " & oGroup.Name
End If
Next
intPwdExpired = objUser.Get("PasswordExpired")
If intPwdExpired = 1 Then
objPwdExpiredTrue = "Yes"
Else: objPwdExpiredTrue = "No"
End If
objFlags = objUser.Get("UserFlags")
If (objFlags And &H40) <> 0 Then
objChangePwdTrue = "No"
Else: objChangePwdTrue = "Yes"
End If
objPwdExpires = objUser.Get("UserFlags")
If (objPwdExpires And &H10000) <> 0 Then
objPwdExpiresTrue = "Yes"
Else: objPwdExpiresTrue = "No"
End If
If objUser.AccountDisabled = True Then
objAccountDisabled = "Yes"
Else: objAccountDisabled = "No"
End If
oPwdAge = objUser.Get("PasswordAge")
objPwdAge = FormatNumber(((oPwdAge / 60) / 60) / 24, 0)
If objUserProfile = "" Then
objUserProfile = "" & vbTab
Else: objUserProfile = objUserProfile
End If
sMessage = "Domain: " & objDomain & vbTab & "User Name: " & "test" & vbTab & "Full Name: " & objUser.FullName & vbTab & vbTab & "Description: " & objUser.Description & vbCrLf & vbCrLf & "Password Expired: " & objPwdExpiredTrue & vbTab & "User can change Pwd: " & objChangePwdTrue & vbTab & "Account Disabled: " & objAccountDisabled & vbTab & vbTab & "Account Locked Out: " & objUser.IsAccountLocked & vbTab & "Password Age: " & objPwdAge & vbCrLf & vbCrLf & "Bad Logins: " & objBadLogins & vbTab & vbTab & "Last logon: " & objUser.LastLogin & vbTab & "Password Never Expires: " & objPwdExpiresTrue & vbTab & "Password Minimum Length: " & objUser.PasswordMinimumLength & vbCrLf & vbCrLf & "User Profile Path: " & objUserProfile & "Home Directory: " & objUser.HomeDirectory & vbTab & "Login Script: " & objUser.LoginScript & vbCrLf & vbCrLf & "User Groups: " & vbCrLf & vbCrLf & gList & vbCrLf
MsgBox sMessage

Activex Component Can't Create Object
i downloaded the neocaption dll and sample files from http://www.vbaccelerator.com/home/VB...ns/article.asp
when i try to run it, or even the exe file that comes with it, i get the error activex component can't create object on the line m_cN.Attach2 Me, m_cSkin
(you probably have to download the files to see the full code)
please help
wakjah

Code:
Private Sub mnuView_Click(Index As Integer)
Dim i As Long
For i = 0 To 6
If (i <> 1) Then
mnuView(i).Checked = (Index = i)
End If
Next i

' can't customise the default
mnuView(8).Enabled = Not (mnuView(0).Checked)

Select Case Index
Case 0
m_cN.Detach
Set m_cSkin = Nothing
setColors
Form_Resize
Case 2 To 6
SelectNewSkin Index
m_cN.Attach2 Me, m_cSkin
setColors
If Index = 5 Then
txtDemo.BackColor = RGB(140, 139, 139)
End If
Form_Resize
Case 8
CustomiseSkin
End Select

End Sub

Activex Component Cant Create Object
i created a prog. that used the redemption outlook library;
you can find that here at http://www.dimastr.com/redemption

it lets you bypass Outlooks "Do you want to send this email?" message pop up when you try to send an email programatically

nway, when i built the app, the thing works fine; by itself, it works fine
i added it as a service to win2k, and now
its says, "activex component cant create object" error
(i registered the dll and everything)

help?

ActiveX Component Cannot Create Object
Hi. I recently downloaded a couple of *.dll files that Im trying to use in my project. I called in my references and when I run my project the fisrt error that appears me is ActiveX Component cannot create object.

What could be the problem?

Thanks

ActiveX Component Can't Create Object
Hi, I have made an application that uses DAO 3.51 and ADO 2.1 Together (older portions work DAO, and I am converting it day by day all into ADO) but I have a problem when the program installs on other machines. Some machines report ActiveX compononent can't create object even if MDACTYP 2.0 & 2.1 are installed. If I install my program on a clean windows 98 environment with both mdacs installed, the program works perfectly. This problem was reported on Windows2000 and Windows 98 computers. Where could I focus on finding the problem or what file is missing in these computers ?

ActiveX Component Can't Create Object
Urgent! Please help!

Here is the information for my developing environment:

Old Environment:
Window NT with service pack 6a
Visual Basic 5.0
Microsoft SQL Server 7.0 with service pack 3
Microsoft Office 97 Professional
Crystal Report 6.0

New Environment(another PC):
Window 2000 with service pack 3
Visual Basic 6.0 with service pack 5
Miscrosoft SQL Server 7.0 with service pack 3
Microsoft Office 2000 Standard
Crystal Report 9.0

My program could load, run and compile without any problem when I was using Visual Basic 5.0. However, when I moved my existing program to the Visual Basic 6.0, the executable file could not be created with this error message - "ActiveX component can't create object".
I've heard that Office 2000 may be the reason for getting this error. So I've uninstalled the office 2000 and created the .exe file again, but the problem still exist. The program can be run from the Visual Basic 6.0 without any problem, but the problem is I can't generate the executable file. Any suggestion for solving this problem is appreciated.

ActiveX Component Can't Create Object
We have an application developed using VB6. This application creates a word (ADO, CreateObject) document. Once this word document is created successfully, then a postscript-file will be generated using Adobe PDF. On successful creation of postscript-file, a new PDF file will be created using PdfDistiller6. Once PDF file is created, word document and postscript files will be deleted.

This application (exe) is running daily (7x24), as a windows service on a dedicated WIN2K (18GB HDD, 1GB RAM) server. Server is installed with MS Office - Service Pack 3 and Windows - Service Pack 4. Application as such running fine for 5-6 days. On 5/6th day we are getting the following errors,
"ActiveX component can't create object" and error number "429".
"File not found" and error number"53"
"Invalid procedure call or argument" and error number "5"

Would appreciate your help to resolve the above problem.

Use COM Object From Excel VBA - Made In .NET "ActiveX Component Can't Create Object"

I have been unsuccessful at deploying a .NET project I created for Excel (VBA). I have this thread open in the VBA section. I figure I would try it in a higher traffic area of the site.http://www.vbforums.com/showthread.p...hreadid=285832Thanks

I have been unsuccessful at deploying a .NET project I created for Excel (VBA). I have this thread open in the VBA section. I figure I would try it in a higher traffic area of the site.

http://www.vbforums.com/showthread.p...hreadid=285832

Thanks