Balokcrom wrote...
I'm having a problem when trying to run @RISK on Excel. I receive the
error
message regarding Microsoft Visual Basic, Run-time Error '429'--You do not
have an appropriate license to use this functionality. I thought it was a
problem with @RISK, but I've tried running my full version, along with
installing the trial version from the website, and the same error message
comes up. Can anyone help me with this problem?
Hi,
You didn't say what version of Excel you are using. Below is one potential
answer I found in the archives.
You might wish to view the archives yourself.
http://www.google.com/advanced_group_search?q=group:*excel
I used "@risk 429" (w/o quotes) as the search words.
Let us know if this helps.
Regards,
Kevin
Kim Apr 25 1999, 12:00 am
Newsgroups: microsoft.public.excel.programming
From: "Kim" <
[email protected]> - Find messages by this author
Date: 1999/04/25
Subject: Re: ActiveX component can't create object
Hi Timothy,
The following is an extract of MS KB article 189607.
HTH
Kim
DAO Error After Installing Visual Basic DAO Application
---------------------------------------------------------------------
The information in this article applies to:
- Microsoft Visual Basic Professional and Enterprise Editions for
Windows, versions 5.0, 6.0
- Microsoft Excel 97 for Windows
---------------------------------------------------------------------
SYMPTOMS
========
Microsoft Excel 97 may return the following error message when using DAO
3.5, if an application created with Visual Basic 5.0 that uses DAO is
installed.
"Run-time error '429': ActiveX component can't create object"
CAUSE
=====
If Microsoft Excel 97 is installed after an application created with
Microsoft Visual Basic 5.0 that uses DAO is installed, Excel does not add
the DAO design-time licensing key. This licensing key is required by Excel,
but is not required by applications created with Visual Basic.
NOTE: The same licensing key is also required and added by Visual Basic
5.0. Because Visual Basic adds the same DAO design-time licensing key
required by Excel, the problem does not occur if Visual Basic is installed.
RESOLUTION
==========
To resolve this problem, add the DAO design-time licensing key to the
Registry. Note that you should back up the Registry before you edit it. If
you are running Windows NT, you should also update your Emergency Repair
Disk (ERD).
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall your operating system. Microsoft cannot
guarantee that problems resulting from the incorrect use of Registry Editor
can be solved. Use Registry Editor at your own risk.
Step-by-Step Instructions
-------------------------
1. From the Start menu, choose Run, enter "regedit", and press the ENTER
key. The Registration Editor appears.
2. In the Registration Editor, browse to HKEY_CLASSES_ROOT\LICENSES.
3. From the Edit menu, select New, then choose Key. A new registry key
appears.
4. Enter "F4FC596D-DFFE-11CF-9551-00AA00A3DC45" (without quotes) as the
name of the new key.
5. In the right-hand window pane, double-click on the Default entry for the
key you created.
6. Enter "mbmabptebkjcdlgtjmskjwtsdhjbmkmwtrak" (without quotes) as the
Value Data, and press enter.
7. If you need to update multiple PCs, create a REG file for that key by
choosing 'Export Registry File' from the Registry menu. Then, copy the
REG file to other PCs and double-click on it to add the key to the
registry.
8. Choose Exit from the Registry menu to close the Registration Editor.
STATUS
======
Microsoft has confirmed this to be a problem in Microsoft Excel 97. We are
researching this bug and will post new information here in the Microsoft
Knowledge Base as it becomes available.
MORE INFORMATION
================
Steps to Reproduce Behavior
---------------------------
1. Make sure that neither Visual Basic 5.0 nor Excel 97 have been
installed. If one or both of them have been installed, then delete the
following key:
HKEY_CLASSES_ROOT\LICENSES\F4FC596D-DFFE-11CF-9551-00AA00A3DC45
NOTE: The problem will not reproduce if the following key exists:
HKEY_CLASSES_ROOT\LICENSES\F4FC596D-DFFE-11CF-9551-00AA00A3DC45
2. Install a simple Visual Basic 5.0 application that has a reference to
DAO 3.5.
3. Install Excel 97.
4. Start Excel and, in a new workbook, create a reference to DAO 3.5. Try
to run the following code:
Sub Macro1()
Debug.Print DBEngine.Version
End Sub
Note that you get the error:
"Run-time error '429': ActiveX component can't create object".
REFERENCES
==========
For information about how to edit the Registry, view the "Changing Keys And
Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete
Information in the Registry" and "Edit Registry Data" Help topics in
Regedt32.exe.
