Applies to
Microsoft Excel 97 and 2000

For download and other information, see Using Date Migration Tools 2.0.

Installation recommendations

The recommended way to install the Date Migration Tools is to run the installation program on every system individually. The installation program copies the necessary files to the right locations, makes the required changes to the Windows® registry, and then loads the add-in program for Excel. For the installation program to run successfully, it must be able to read and write to the Windows registry. If you use system policies to lock down users' options, you will need to unlock the options for the installation program to run successfully.

Installation alternatives

For corporate environments that use customized installation methods, it's possible to do a custom deployment of the date migration tools. The following sections describe the files in the package and where each must be copied for both Excel 97 and 2000. It also describes the registry keys used by the tools so that your custom deployment can set these keys if desired.

The Date Migration Tools install the files shown in the following table. The default location for these files is Program Files/DMW, but you can specify a different location during installation.

File	Purpose
DMW.dll	Wizard function call library and code.
DMW_97.xla	The Excel add-in for the wizards.
Eula97.rtf	End-user license agreement displayed by the installation program.
Install.log	Text file that logs the files that were copied and the registry keys that were modified by the installation program.
Readme97.txt	Text file displayed when you click the Help button in the first step of the Date Migration Wizard.
Unwise.exe	Program that uninstalls the Date Migration Tools when you use Add/Remove Programs from Control Panel.
Unwise.ini	Configuration file for Unwise.exe.
XLDigKil.exe	Bypasses any Excel alerts while the wizards are scanning files.

The installation program installs the following system files or updates them if you don't have the latest version on your system. These files are installed in the Windows\System32 folder.

File
Asycfilt.dll
Comcat.dll
Mscomct2.ocx
Msvbvm60.dl
Oleaut32.dll
Olepro32.dll
Stdole2.tlb

The Date Migration Tools use the following registry keys:

Load the Data Migration Tools add-in program

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
Key: OpenX
Default value: "C:\program Files\DMW\DMW_97.xla"
Type: String

This key determines whether the add-in program is loaded by default when Excel starts. The X in the OpenX key is a number determined by the number of other OPEN keys in Options (the number of other add-in programs to be loaded). The value is the path to file DMW_97.xla on your system.

Date Watch Wizard: enable or disable the wizard

HKEY_CURRENT_USER\Software\VB and VBA Program Settings\DMW\DMW
Key: Enabled
Default value: "False"
Type: String

Equivalent to checking (True) or clearing (False) the Enable Date Watch check box in the Date Watch dialog box. If you have workbooks that contain XLM macros, turn this option off.

Date Watch Wizard: fix two-digit years

HKEY_CURRENT_USER\Software\VB and VBA Program Settings\DMW\DMW
Key: 4DigitYear
Default value: "True"
Type: String

Equivalent to checking (True) or clearing (False) the As new dates are entered, change to 4-digit year format check box in the Date Watch dialog box. This option changes number formats to use four-digit years when you type dates with two-digit years.

Date Watch Wizard: detect all functions

HKEY_CURRENT_USER\Software\VB and VBA Program Settings\DMW\DMW
Key: AlertForAll
Default value: "True"
Type: String

Equivalent to checking (True) or clearing (False) the Alert for all date functions check box in the Date Watch dialog box. This option warns you if you use a text date with a two-digit year in one of the functions that accept text dates as arguments, listed previously in this article.

Date Watch Wizard: warn about dates in text files

HKEY_CURRENT_USER\Software\VB and VBA Program Settings\DMW\DMW
Key: TextFileWarning
Default value: "True"
Type: String

Equivalent to checking (True) or clearing (False) the Display date warning check box in the Date Watch dialog box. This option warns you if you open a text file that contains dates with two-digit years.

For information about Office deployment, including setting up custom installation, working with registry settings, and using system policies, see the Office Resource Kit.