Visual Basic :: Big Problem With &"activeX Component Cant Create Object&" #429

&"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?

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=285832

Thanks

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+ 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

&"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!

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!

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

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?

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

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

Need Help With Using &"ActiveSkin&" (ActiveX Component)
Does anyone know how to use ActiveSkin?

I'm using ActiveSkin (4.3) and have successfully managed to import it as an ActiveX object. I've also managed to drag an instance of it onto my Form1, and have selected the type of skin I'm trying to use. But when I run the form nothing happens ... the form remains unchanged.

I know I need to paste some kind of code onto the form to make it work, but don't know what code to use. I've tried reading the HelpGuide that comes with the product but don't understand it ... it's not very noob-friendly. I've also tried googling for HelpGuides on ActiveSkin but can't find anything useful.

Does anyone know how to use this component properly? All I'm trying to do is give my form a 'MacOSX' type of look.

Edited by - paranoyd on 2/4/2008 1:27:00 AM

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?!? ;)

Where To Download &"DirectStudio98&" Of Arakelian Soft And &"ActiveX For VB&" Of TegoSoft?
I want those two ActiveXControls to use power of DirectX in VB.
They're free Controls, right?
Where can I download them?
Thank you!
It seems both of the two companies don't provide those controls directly now.
Please give me the links to the controls.
Or any controls related will be OK!
Thank you very much!

If I Use "SaveSetting App.Title, "Settings", "Font", "001122"" - Save Date In The Registry, Where Ca
If i use "SaveSetting App.Title, "Settings", "Font", "001122"" - save date in the registry, where can i find the value saved in the registry? Thanks

How Can I Create An ActiveX Dll For &"Hello World&". Pls Help
How can I create an ActiveX dll for "Hello world" and then call it later on from a program or how to use it?! Pls help

Because I am very new to this. Can you please help me how to do this. How to create one ActiveX dll and then call it later on or how to use this created Active X dll in a program.
Thanks in advance

How To Create A &"Back&" And &"Forward&" Button For The Web Browser Control
Does anyone know how to create a "Back" and "Forward" button for the web browser control? Thanks in advance.

ActiveX.dll &"Object Variable Not Set&"
I created my own ActiveX.dll as an experiment:

Code:
option explicit
Public Function SayHi(ByVal lRet As Long) As String
Select Case lRet
Case 0
SayHi = "No response"
Case 1
SayHi = "Success!"
Case 2
SayHi = "Near Miss!"
Case 3
SayHi = "End of file"
Case Else
SayHi = "Unknown result: " & CStr(lRet)
End Select
End Function
To test it, I created a form with a button, and when you click the button, you see the following

Code:
Dim objProcs As MyDll.clsFirst

Private Sub Command1_Click()
sSQL = objProcs.SayHi(lRet)
End Sub
I run it and get the error "Object variable or With block variable not set"

I of course tried to Dim objProc as Object and set the object, but to no avail.

How am I screwing up?

Keep Getting &"can't Create Object&" Error
Hi All

I have recently built a application that reads outlook emails and
extracts email addresses from the body of the mail.

My Problem:

The application works fine on my machine "windows me" but when i run it on a 95 or 98 I get the error:

"Runtime error 429, Axtivex component can't create object"

I can find load's of references to it in MSDN but none that seem to be specific to my problem.

Here is the code where the problem appears:

Dim objOutlook As New outlook.Application
Dim objNameSpace As outlook.NameSpace
Dim objFolder As MAPIFolder
Dim objMail As MailItem
Dim theseMails As Integer
Dim i
Dim messages As String
MsgBox "before set object" This fires ok
amountOfmails = 0
' Get the MAPI name space
Set objOutlook = CreateObject("outlook.Application")

Set objNameSpace = objOutlook.GetNamespace("MAPI")
MsgBox "After set object" I do not get as far as this message

I hope someone can help

Malcolm

How Can I Create A Picture &"object&" ?
I made this bitmap and saved as a seperate file using a form and a picturebox control, but how am I supposed to do this on a console environment such as the Internet? Theoretically, I judge that I have to create a picture object by createobject statement and use its methods to form the image. Which object should that be ? Any other ideas ?

Win 98 &"CAN'T CREATE OBJECT&" Error 429
I have some clients running my application on Win98 who experience this error when starting up the program. I am using VB6, DAO and I am using Mirosoft Internet Controls in the app.

How do I avoid this error?

Thanks for any suggestions.

David Abineri

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

ActiveX-Error 429-ActiveX Component Can't Create Object
I am having this message when doing interfacing with MATLAB as the following codes
<vbcodes>
Set MatLab = CreateObject("Matlab.Application")
</vbcodes>

What should I do. I am using Windows XP Professional. Is that version doesn't support ActiveX for interface with Matlab?
Tq

'Method &"Range&" Of Object &"_Global&" Failed.' ???
Hi!

I'm trying to create a VB app that interfaces with an Excel file. I can access the file okay. Part of the code is finding the next empty row in a range. I keep getting an error in the set range part of the code.

Code:
Dim rangeSearch As Range

xlSheet.Columns("A").Select
Set rangeSearch = Selection.Find(what:="*", After:=Range("A1"), lookin:=xlFormulas, _
lookat:=xlWhole, searchorder:=xlByRows, SearchDirection:=xlNext)
If Not rangeSearch Is Nothing Then
FindLastRow = rangeSearch.Row
MsgBox rangeSearch.Row
End If

The error is 'Method "Range" of object "_Global" failed.'

Anyone have any idea what this means?

Thanks!!!

Method &"Range&" Of Object &"_Worksheet&" Failed....???
What ever I do on this line:

Sheet1.Range(strColumn & 3).Value = strValue

I get an error:

Method "Range" of object "_Worksheet" failed.

I tried at least 10 different ways! What's wrong?? THIS line works fine:

LColorCells = "A" & Lrow & ":" & "J" & Lrow
Sheet1.Range(LColorCells).Font.Color = vbwhite

So what's wrong with the above line??

I've tried for example:

Sheet1.Range("" &strColumn & str(3)).Value = strValue
Sheet1.Range("'" &strColumn & 3 &"'").Value = strValue

and more...

What's strange is that THIS WORKS:

Sheet1.Range("D" & 3).Value = strValue

But of course, he would only use Column "D" and I need to loop it cause strColumn is changing.

Can someone tell me what's wrong?
Thanks!

Edited by - Zvi on 11/8/2006 10:53:20 PM

Easy Way To Create &"AA&" &"BA&" &"CA&"... From A Number?
Hello All,

Looking for an easy way to convert the number 27 into column AA, 52 int "AZ" etc. (I think thats right! for 52 ...)

Or, is there anyway I just use (3,3) for "C3"?

Example:
appExcel.Range( ??? ).Value = SomeDataInArray

This has GOT to be easy, I just can't find reference, and I didn't want to hard code it if I don't have to.

Sprig

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