Visual Basic :: Pocket PC 2000 Emulator: ActiveX &"Can't Create Object&" Bug (Q260150)

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

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

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

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

How To Create A Folder In &"My Documents&" Folder In Pocket PC Device?
Hi Friends,

Can anyone help me to create a folder in "My Documents" folder in Pocket PC device via Application Install Wizard...?

I really appreciate your help!

Regards,
Zorik

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

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

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!

Create XP, 2000 And Me &"Balloons&"?
Hello!

How can I use the text balloons present in Windows XP, 2000, Me?

Thanks!

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

'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

&"Run-time Error 424 - Object Required&" Error When Upgrading A Activex Control
When I compile (upgrade) a activex control the program using it gives an error saying "Run-time error '424' - Object Required". If you delete the object from the vbp file and reopens the program and add the component again it'll work just fine.. But as soon as I try to upgrade this error will occur when trying to see the form of the new project using the upgraded activex control. The upgrade procedure seems to work fine though and the error occurs, as I said, only when I try to see the form of the project.

How To Create Object Without Using &"NEW&"?
I want to create a instance of class, but it's only a "private" class in this project, so i can't use "CreateObject".

and i can't know which class i want to create from. it's like this:

private function createNewInstance(obj as object) as object

end function

i want this function return a new object like obj, but VB6 does not support reflection like .Net, so how can i do?

&"can't Create Object&"
Hi there. I have a VB5 database application that I've been working on for a while on my desktop, and it has been coming along ok. When I run it (uncompiled) it runs as expected.

I have now installed VB 5.0 on my laptop to work on it on the road. However, when I try to run it now, it crashes as soon as I try to get to any of the data access areas. The error message I get is :-

Run time error '429':
ActiveX component can't create object.

If I click 'debug', the line that is highlighted is:-

"Set db = OpenDatabase(App.Path & "Employees.mdb")"

As I said, it works fine on my desktop, but not on my laptop. Both are running Windows XP Pro.

Thanks for any help.

Richard

Solution> Error: &"&"&"&"&H8007007E (-2147024770) The Specified Module Cannot Be Found&"&"&"
Hello

This is the error what i am getting after installing a package of one of my module on user testing machine.
The same module being working fine on others.

What can be the reason for this and what can be the probable solution for this?

Sandeep

Simple &"emulator&"
Hey,

Some one in another post told me that i could run a vb program on Unix/Linux with a emulator, can some one tell me what that is and how i can get/make one.

thanks,
dclamp

Help! I Am Getting That Error &"could Not Be Created&", But In My Pocket PC!
Hello world!!! This is my first message!!!
Well, I am developing an application using Embedded Visual Basic, and I got that famous problem with the emulator, which was like "OBJECT could not be created..."... then I fixed it using the file posted on this forum (thank you very much!!!), but I am having this error on my Pocket!!! What I have to do??? I have a HP Jornada with Pocket PC 2002...

Thanks a lot!!!

How To Disable &"Settings&" In Pocket Pc?
Hi,

Is anyone here know how to disable
"Settings" in Pocket PC using eVB?
Coz I don't want the user to configure
settings in the Pocket PC.

Thanks for your advice.

"server Not Yet Been Opened" & "Object Variable Or With Block Variable Not Set" Error
I'm a new user of Crystal Report 8.5. I'm using VB6 and SQL Server 2000. I have designed a report at CR 8.5 and inserted it on VB 6, how will I connect?
I have tried a sample code below but I'm getting an "Object variable or with block variable not set" error. How do I solve this? Please Help. Thanks in advance Gurus

'General Declaration
Dim Report As New CrystalReport1
Dim crApp As New CRAXDRT.Application
Dim crReport As CRAXDRT.Report
Option Explicit

Private Sub Form_Load()
Dim crTable As cRAXDDRT.DatabaseTable
Set crReport = crApp.OpenReport("c:durden mmiclossratioreport.r pt")
crTable.SetLogOnInfo "servername", "dbasename", "userid", "password"
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
End Sub

And when I'm using this code, I'm getting a "Server has not yet been opened" error.

'General Declaration
Dim Report As New CrystalReport1
Dim crApp As New CRAXDRT.Application
Dim crReport As CRAXDRT.Report
Option Explicit

Private Sub Form_Load()
Dim crTable As cRAXDDRT.DatabaseTable
Set crReport = crApp.OpenReport("c:aris mmiclossratioreport.rpt ")
crReport.Database.Tables(1).SetLogOnInfo "mis002", "mqs", "aris", "110796"
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
End Sub

--

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?