Solved

VB5 CreateObject("Word.Basic") Doesn't Work for me

Posted on 1998-05-06
5
539 Views
Last Modified: 2013-11-25
I'm creating an OLE interface with Word97 and I when I set an Object = CreateObject("Word.Basic") I get a compiler error
             "Run time Error 429 "
             "Active X component can't create object"
I've referenced the Microsoft Office Library. What am I doing wrong?

Thanks in advance for your help.
0
Comment
Question by:WDB
5 Comments
 
LVL 1

Expert Comment

by:chualk
ID: 1442520
Try this :

Sub command1_click()

Dim xlApp As Object
   
Set xlApp = CreateObject("word.basic")

xlApp.AppShow



Remember to set xlapp = nothing after you do not need the object.

Regards,
Chualk
0
 
LVL 2

Author Comment

by:WDB
ID: 1442521
Thanks for your response chualk's.

That's how I had it before and I still get the error. I'm referencing the Word 8.0 Object library as well as the VB Visual Basic for Applications extensibility.
0
 
LVL 5

Accepted Solution

by:
bin_huwairib earned 50 total points
ID: 1442522
WDB,

Your statement is OK, but you have a problem with DCOM settings, take a look at the following artical it might help you out.

PSS ID Number: Q177394

The following is a list of possible causes of Run-time error 429. It is by no means a complete or definitive list.
 
Problem with Server Run Location
--------------------------------
 
This scenario applies to Microsoft Windows NT and Microsoft Windows 95 servers.
 
1. On the Server machine run the DCOM Config utility (Dcomcnfg.exe).
 
2. Select the DCOM Server from the Applications tab and choose the Properties button.
 
3. Select the Location tab.
 
4. Ensure the  Run application on this computer  setting is checked.
 
Incorrect Server Specified in Client Registry
---------------------------------------------
 
On the client machine, use the following steps to verify that the DCOM Server machine is properly delegated. This scenario applies to Windows NT and Windows 95 clients.
 
1. On the client machine run the DCOM Config utility (Dcomcnfg.exe).
 
2. Select the DCOM Server from the Applications tab and choose properties.
 
3. On the General tab be sure that there is an entry for  Remote Computer and that the remote computer name is correct.
 
4. If the computer name is incorrect, select the Location tab.
 
5. Ensure the  Run application on the following computer setting is checked. In the dialog box beneath this selection, type in the correct computer name for your DCOM Server.
 
You may also use the following steps to verify the remote computer name by using the Windows Registry.
 
1. Run RegEdit.exe.
 
2. The remote server name is specified in the following registry key:
 
      HKEY_CLASSES_ROOT\
         APPID\
            {The CLSID of the DCOM Server}\
               RemoteServerName
 
Enable Remote Connections is Disabled
-------------------------------------
 
On Windows 95 servers only, you must be sure remote connections are enabled in order for a remote application to access and execute a serving application. The following steps can be used to perform this task.
 
1. Run DCOM Config (Dcomcnfg.exe).
 
2. Select the Default Security tab.
 
3. Check the  Enable remote connection  check box.
 
- or -
 
1. Run RegEdit.exe.
 
2. Locate the following registry key:
 
      HKEY_LOCAL_MACHINE\
         Software\
            Microsoft\
               OLE\
                  EnableRemoteConnect
 
3. Ensure the EnableRemoteConnect value is set to  Y  for Yes.
 
Remote Component not Started
----------------------------
 
On Windows 95 servers only, the DCOM Server application must be started before a remote client may access it. DCOM Server applications on Windows NT Servers do not have this limitation.
 
Binary Compatibility is Broken
------------------------------
 
1. Open the DCOM Server project.
 
2. From the Project menu, choose the project Properties.
 
3. On the Component tab ensure  Binary Compatibility  is selected.
 
If  Binary Compatibility  is not set, a new GUID (a.k.a ClassID) is not created each time the DCOM Server project is compiled. If you do not recompile the Client application after a new GUID is assigned, the DCOM clients will break.
 
Use the following steps to resolve this issue:
 
1. Set the DCOM Server project to  Binary Compatibility.
 
2. Recompile both the Server and Client application.
 
In the future, if you make any interface changes to your DCOM Server which may break compatibility, the Visual Basic compiler warns you that the component is no longer binary compatible. If you proceed to compile the DCOM Server, thus breaking compatibility, you must recompile any client applications which refer to that server. For more information about compatibility see the References section below.
 

Best regards
Bin Huwairib
0
 
LVL 6

Expert Comment

by:clifABB
ID: 1442523
It's strange that chualk's code didn't work for you, it worked on my machine.

Perhaps you have a bod install of Word (or VB?).


0
 

Expert Comment

by:r_aparajit
ID: 1442524
Instead of "Word.Basic" ,You just try "Word.Application" &
give a reference to Word 8.0 Object library in reference dialog box.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now