Microsoft KB Archive/129422

{|
 * width="100%"|

XL5: Network Admin Method for Updating Registration Database

 * }

Q129422

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c

-

SUMMARY
If you are a network administrator, you may want use a batch method to update users' REG.DAT files. For example, you may want to do this if you want all network users to move their object library (.OLB) files to their local workstations.

For information about a situation in which you would want to use this method, please see the following article in the Microsoft Knowledge Base:

"Q120404 XL5: 'File Not Found' Error Using References Dialog Box"

MORE INFORMATION
To have users update references in the Windows registration database file, REG.DAT, use the steps below to create a .REG file.

Creating a .REG File
To correct this type of problem for many workstations, you can create and distribute a .REG file to the users that have the problem. The users can double-click the .REG file in Windows File Manager to automatically update the REG.DAT entry. A .REG file that you create must follow certain requirements in order to update the REG.DAT file correctly:


 * The file be in ASCII text.
 * The word REGEDIT must be the only word on the first line of the file.
 * The additional lines of the file include a "path" to the key to be updated and a value for that key.

Example .REG file
Microsoft does not support customer modifications to the REG.DAT file. You should use caution when you make changes to the Windows registration database. Always make a backup copy of the REG.DAT file before you change it. Microsoft provides this example for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This example is provided "as is" and Microsoft in no way guaranties that the following information can be used in all situations.

The following is an example of a file that can be used to update the entries for the XLEN50.OLB file and the VBAEN.OLB file discussed above.

  In a text editor, such as Notepad, enter the following text in a new file. REGEDIT

HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-

000000000046}\1.0\9\win16 = C:\EXCEL\XLEN50.OLB

HKEY_CLASSES_ROOT\TypeLib\{000204F3-0000-0000-C000-

000000000046}\1.0\9\win16 = C:\WINDOWS\SYSTEM\VBAEN.OLB Note that in the above example, the directories C:\EXCEL and C:\WINDOWS must be the Microsoft Excel directory and the Microsoft Windows directory respectively on the users workstation.  Save the file as CORRECT.REG. (Note that you can give this file any valid MS-DOS filename. However, in order for the file to be associated with the registration database by default, you should give the file the extension .REG). Distribute the file to the users who are experiencing this problem. To correct the problem, the user must double-click the .REG file in File Manager to merge this information into the Registration Database file on their computer.

NOTES:

The formatting of this article may force the example entries above to wrap to the following line. All entries in the .REG file must be entered on a single line. In the above example, a blank line is inserted between each entry.

There are 10 zeros in the above numeric sequence "000000000046". Failure to enter this information EXACTLY as shown above will result in the creation of a NEW ENTRY in your REG.DAT file, and the desired result will not be achieved. (It is most likely that no error message will be given, and no adverse effects will occur.)

There should be a carriage return character at the end of every line of text. Additional query words: 5.00c reg dat vbaen xlen50 novell vlm .vlm banyan vines vine ghost drive

Keywords :

Issue type :

Technology :