Appendix B: Registry Keys and Values

This appendix contains information about registry entries created in and used by the various Microsoft Office for Windows 95 applications.
Microsoft Office and the various Office applications store initialization information as part of the Windows registry. The Windows registry is a centralized database that Windows uses to set up and configure the software and hardware running in your Windows environment. The registry is analogous to the .ini files used in Windows 3.x; each key in the registry is similar to a bracketed heading in an .ini file, and values under a registry key are similar to entries under an .ini file heading. 

Caution   Many registry settings are added automatically when you install Microsoft Office. Changing the installed settings can produce unexpected results, which may make it necessary for you to reinstall Microsoft Office. It is strongly recommended that you do not change settings in the Windows registry. However, if you must change settings and options, use the Registry Editor, and only change those settings or options that are explicitly documented in the topics below. The revised settings take effect the next time you start Microsoft Office.

  
Note   In future versions of Office, the locations and values of any of these registry keys may change without notice and without being backward compatible.
  
Using the Registry Editor
To edit registry settings in either Microsoft Windows 95 or Microsoft Windows NT, use the Registry Editor.
If there is a plus sign (+) to the left of the folder, that registry key contains additional keys. To edit a registry key’s values, double-click the key’s folder in the left pane of the Registry Editor window to open it, and then double-click the value you want to edit in the right pane of the Registry Editor window. In some cases, you may need to add new keys or values. For more information, use the Help menu on the Registry Editor menu bar.
To start the Registry Editor in Windows 95
 1.	Click the Windows Start button, and then click Run.
 2.	Type regedit and then click OK.
 3.	Double-click the folder icons to navigate to the appropriate registry folder.
  
To start the Registry Editor in Windows NT
 1.	Open or switch to either Program Manager or File Manager.
 2.	On the File menu, click Run.
 3.	Type regedt32 and then click OK.
 4.	Double-click folder names to navigate to the appropriate registry folder. 
  
Microsoft Access Registry Keys and Values
As is true for all the other Office applications, Microsoft Access stores its initialization information as part of the Windows registry. 
Instead of editing the registry, if you have the Access Developers Toolkit for Microsoft Access for Windows 95, you can use the Setup Wizard included with it to create an installation program for a custom Microsoft Access application and create a user profile. A user profile is an alternative set of registry keys containing settings that override the standard Microsoft Access and Microsoft Jet 3.0 settings when running that application. User profiles are analogous to Appname.ini files that are used in previous versions of Microsoft Access. User profiles are invoked by issuing the /profile command-line option when starting Microsoft Access.
Customizing Builders, Wizards, and Add-ins
Instead of editing registry settings, in most cases you can customize builders, wizards, and other add-ins using options available in their dialog boxes. For more information, see Chapter 12, “Using Library Databases and Dynamic-Link Libraries,” and Chapter 16, “Creating Wizards, Builders, and Add-ins,” in Building Applications with Microsoft Access for Windows 95.
Using the Registry Editor
The main subtrees containing settings that affect Microsoft Access are as follows:
·	\\Hkey_Current_User\Software\Microsoft\Access\7.0
·	\\Hkey_Local_Machine\Software\Microsoft\Access\7.0
·	\\Hkey_Local_Machine\Software\Microsoft\Jet\3.0
  
The folders that are displayed below the \Microsoft\Access\7.0 folders apply specifically to Microsoft Access 7.0. The folders that are displayed below the \Microsoft\Jet\3.0 folder apply to the Microsoft Jet database engine that Microsoft Access uses for data access. Other programs, such as Microsoft Excel for Windows 95 and Visual Basic 4.0, may also use the Jet database engine. 
Microsoft Access Hkey_Current_User Settings
The following sections describe the values contained in the \\Hkey_Current_User\Software\Microsoft\Access\7.0\Settings key. The Hkey_Current_User key points to a branch of Hkey_Users for the user who is currently logged on.
  
Entry	Type	Description

LastUser	String	Records the user name of the last user who logged on to Microsoft Access. If the Logon dialog box has not been activated, this value is always the default user “Admin.”
Maximized	DWORD	Indicates whether or not the application fills the screen.0 = Application window size and position are set by the WindowTop, WindowLeft, WindowHeight, and Window Width values.1 = Application window fills the screen.
WindowTop	DWORD	Sets the distance (in points) from the top of the application window to the top of the screen; when maximized, it is 0. 
WindowLeft	DWORD	Sets the distance (in points) from the left edge of the application window to the left edge of the screen; when maximized, it is 0.
WindowHeight	DWORD	Sets the height (in points) of the application window; when maximized, it is 0.
WindowWidth	DWORD	Sets the width (in points) of the application window; when maximized, it is 0.
Specifying Whether OLE Links Are Saved in OLE 1.0 or 2.0 Format
You can specify whether Microsoft Access saves OLE links in OLE 2.0 format, which saves both relative and absolute link source references, or OLE 1.0 format, which saves only absolute references. An absolute link source reference obtains data from an object that’s stored as a file. A relative link source reference obtains data from an object that may be embedded within a document. Set this option to 1 to ensure consistency of OLE linking operations in Microsoft Access 1.x databases in an environment where both versions 1.x and 7.0 of Microsoft Access are used.
To specify how OLE links are saved
 1.	Start the Registry Editor, and then navigate to the \Hkey_Local_Machine\Software\Microsoft\Access\7.0 key in the registry.
 2.	Double-click the icon for the Options folder. If AllowOLE1LinkFormat is already listed in the Name column in the right pane of the Registry Editor, skip to step 5.
 3.	On the Edit menu, point to New, and then click DWORD Value.
 4.	Type AllowOLE1LinkFormat and then press ENTER.
 5.	Double-click AllowOLE1LinkFormat, and then type 1 in the Value Data box to save in OLE 1.0 link format, or type 0 to save in OLE 2.0 link format.
 6.	Quit the Registry Editor.
  
The next time you start Microsoft Access, it will use the OLE link settings you specified in step 5.
Microsoft Jet Database Engine Initialization Settings
The following sections describe the values used to initialize the Microsoft Jet database engine. These include settings that control how native Jet (Microsoft Access) .mdb files are accessed, as well as settings for other file types, such as dBASE, FoxPro, and Paradox file types.
Global Settings Versus Microsoft Access-Specific Settings
Microsoft Jet database engine settings can be specified in two places:
·	\\Hkey_Local_Machine\Software\Microsoft\Jet\3.0
·	\\Hkey_Local_Machine\Software\Microsoft\Access\7.0\Jet\3.0
  
The settings below the \\Hkey_Local_Machine\Software\Microsoft\Jet\3.0 key affect all programs using the Jet database engine, such as Microsoft Access 7.0, Microsoft Excel 7.0, and Visual Basic 4.0. These settings are called global settings.
A setting in the \\Hkey_Local_Machine\Software\Microsoft\Access\7.0\Jet\3.0 key overrides the corresponding global setting and affects only Microsoft Access. These settings are called Microsoft Access-specific settings.
If you want to change settings to affect all programs using the Jet database engine, change the global settings. However, if you do this, keep in mind that you may be affecting more than just Microsoft Access. If you want changes to Jet database engine settings to affect only Microsoft Access, change the Microsoft Access-specific settings.
The installation process does not write default values for most Jet database engine settings to the registry. No Jet keys or values are written for global Jet database engine settings.
To change global Jet database engine settings
 1.	Start the Registry Editor.
 2.	Open the \\Hkey_Local_Machine\Software\Microsoft\Jet\3.0\Engines subkey.
 3.	If a folder for the key exists below the subkey, open that folder.
	If a folder for the key doesn’t exist below the subkey, add a new key below the subkey and name it appropriately. For example, by default, Setup does not create a folder for Jet\3.0\Engines\Jet global settings. In this case, you need to add a key below the subkey and name it “Jet.”
 4.	If a value that you want to change is specified, double-click the value and then type the new setting.
	If a value that you want to change isn’t specified, do the following for each default value that you want to specify:
·	Add a new value of the specified type (String, DWORD, or Binary).
·	Type the name of the value.
·	Double-click the new value, and then specify its value.

To change Microsoft Access-specific Jet database engine settings
 1.	Start the Registry Editor
 2.	Open the \\Hkey_Local_Machine\Software\Microsoft\Access\7.0\Jet\3.0\Engines subkey.
 3.	If a folder for the key exists below the subkey, open that folder.
	If a folder for the key doesn’t exist below the subkey, add a new key below the subkey and name it appropriately. For example, by default, Setup does not create a folder for Jet\3.0\Engines\Xbase Microsoft Access-specific settings. In this case, you need to add a key below the subkey and name it “Xbase.”
 4.	If a value that you want to change is specified, double-click the value and then type the new setting.
	If a value that you want to change isn’t specified, do the following for each default value that you want to specify:
·	Add a new value of the specified type (String, DWORD, or Binary).
·	Type the name of the value.
·	Double-click the new value, and then specify its value.

  

Caution   Do not delete the SystemDB value in \\Hkey_Local_Machine\Software\Microsoft\Access\7.0\Jet\3.0\Engines\Jet. If you delete this value, Microsoft Access will not work properly; you may not be able to log on to Microsoft Access, and you will not be able to create new databases or perform any security-related actions.

For information about how to add keys or how to create and specify values, see the appropriate Help topics in the Registry Editor.
Microsoft Jet 3.0 Engine Initialization Settings
These settings can be specified in one of the following places, depending on what you want the settings to apply to:
·	To specify settings that apply only to Microsoft Access, use \\Hkey_Local_Machine\Software\Microsoft\Access\7.0\Jet\3.0\Engines\Jet.
·	To specify settings that apply to all programs using Microsoft Jet format databases (*.mdb), use \\Hkey_Local_Machine\Software\Microsoft\Jet\3.0\Engines\Jet.
  
The Setup program does not create the \\Hkey_Local_Machine\Software\Microsoft\Jet\3.0\Engines\Jet folder, and it does not write default values for these settings. You must add this folder and then add and specify values if you want to change default values in this location. Only the SystemDB value is written by the Setup program to the \\Hkey_Local_Machine\Software\Microsoft\Access\7.0\Jet\3.0\Engines\Jet folder. You must add and specify values if you want to change default values in this location.
  
Entry	Type	Description

PageTimeout	DWORD	Length of time between when data that is not read-locked is placed in an internal cache and when it is invalidated, expressed in milliseconds. The default is 5000 milliseconds, or 5 seconds.
LockRetry	DWORD	Number of times to repeat attempts to access a locked page before returning a lock conflict message. The default is 20. 
MaxBufferSize	DWORD	Size of the database engine internal cache, measured in kilobytes (K). MaxBufferSize must be an integer value greater than or equal to 512. The default is based on the following formula:((TotalRAM in MB - 12 MB) / 4) + 512 KBFor example, on a system with 32 MB of RAM, the default buffer size is ((32 MB - 12 MB) / 4) + 512 K or 5632 K. To set the value to the default, set the registry key to the following:MaxBufferSize=
Threads	DWORD	Number of background threads available to the Jet database engine. The default is 3. 
UserCommitSync	String	Specifies whether the system waits for a commit to finish. “Yes” instructs the system to wait; “No” instructs the system to perform the commit asynchronously. The default is Yes. 
ImplicitCommitSync	String	Specifies whether the system waits for a commit to finish. “No” instructs the system to proceed without waiting for the commit to finish; “Yes” instructs the system to wait for the commit to finish. The default is No. 
ExclusiveAsyncDelay	DWORD	Specifies the length of time (in milliseconds) to defer an asynchronous flush of an exclusive database. The default value is 2000, or 2 seconds..
SharedAsyncDelay	DWORD	Specifies the length of time (in milliseconds) to defer an asynchronous flush of a shared database. The default value is 0. 
SystemDB	String	Specifies the full path and filename of the workgroup information file. The default is the appropriate path followed by the filename System.mdw. 
Microsoft Jet 3.0 Engine ISAM Formats
The \\Hkey_Local_Machine\Software\Microsoft\Access\7.0\Jet\3.0\ISAM Formats\Microsoft Access folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Jet 3.0
ExportFilter	String	Microsoft Access (*.mdb)
ImportFilter	String	Microsoft Access (*.mdb)
CanLink	Binary	00
OneTablePerFile	Binary	00
IndexDialog	Binary	00
CreateDBOnExport	Binary	00
ResultTextImport	String	Import data from the external file into the current database. Changing data in the current database will not change data in the external file.
ResultTextLink	String	Create a table in the database that is currently linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport	String	Export data from the current database to a Microsoft Access database. This process will overwrite the data if it is exported to an existing file.
Microsoft Jet 2.x Engine Initialization Settings
These settings are used by the Microsoft Jet database engine when you access database files from Microsoft Access 1.x and 2.0.
When the Microsoft Jet 2.x Engine database driver is installed, the Setup program writes a set of default values to the Windows registry in the Engines and ISAM Formats subkeys. You must use the Registry Editor to add, remove, or change these settings. The following sections describe initialization and ISAM Format settings for the Jet 2.x Engine database driver.
  
Note   The installation procedure writes only one setting (win32) to the Jet\3.0\Engines\Jet 2.x folder; you must add all other engine settings manually.
  
The Jet\3.0\Engines\Jet 2.x folder contains initialization settings for the Microsoft Jet database engine.
  
Entry	Type	Description

win32	String	Location of the database engine driver (.dll). The path is determined at the time of installation. 
PageTimeout	DWORD	Length of time between when data that is not read-locked is placed in an internal cache and when it is invalidated, expressed in 100-millisecond units. The default is 5 units ,or 0.5 seconds.
LockedPageTimeout	DWORD	Length of time between when data that is read-locked is placed in an internal cache and when it is invalidated, expressed in 100-millisecond units. The default is 5 units, or 0.5 seconds.
CursorTimeout	DWORD	Length of time a reference to a page will remain on that page, expressed in 100-millisecond units. The default is 5 units, or 0.5 seconds. This setting applies only to databases created with version 1.x of the Microsoft Jet database engine.
LockRetry	DWORD	Number of times to repeat attempts to access a locked page before returning a lock conflict message. The default is 20 times; LockRetry is related to CommitLockRetry, which is described in the following table entry. 
CommitLockRetry	DWORD	Number of times Jet attempts to acquire a lock on data to commit changes to that data. If Jet cannot acquire a commit lock, changes to the data will be unsuccessful.The number of attempts Jet makes to get a commit lock is directly related to the LockRetry value. For each attempt made to acquire a commit lock, Jet will make as many attempts as specified by the LockRetry value to acquire a lock. For example, if CommitLockRetry is set to 20 and LockRetry is set to 20, Jet will try to acquire a commit lock as many as 20 times; for each of those attempts, Jet will try to acquire a lock as many as 20 times, for a total of 400 attempts.The default value for CommitLockRetry is 20. 
MaxBufferSize	DWORD	Size of the database engine internal cache, measured in kilobytes (K). MaxBufferSize must be a whole number value between 9 and 4096, inclusive. The default is 512. 
ReadAheadPages	DWORD	Number of pages to read ahead when performing sequential scans. The default is 16.
IdleFrequency	DWORD	Amount of time, in 100-millisecond units, that Jet will wait before releasing a read lock. The default is 10 units, or 1 second. 
Microsoft Jet 2.x Engine ISAM Settings
The Jet\3.0\ISAM Formats\Jet 2.x folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Jet 2.x
OneTablePerFile	Binary	00
IndexDialog	Binary	00
CreateDBOnExport	Binary	00
IsamType	DWORD	0
Microsoft Excel Initialization Settings
The Jet\3.0\Engines\Excel folder includes initialization settings for the Msxl3032.dll driver, used for external access to Microsoft Excel worksheets.
The Microsoft Jet database engine uses the Excel folder entries listed in the following table.
  
Entry	Type	Description

win32	String	Location of Msxl3032.dll. The full path is determined at the time of installation. 
TypeGuessRows	DWORD	Number of rows to be checked for the data type. The data type is determined based on the maximum number of data types found. If there is a tie, the data type is determined in the following order: Number, Currency, Date, Text, Boolean. If data is encountered that does not match the data type guessed for the column, it is returned as a Null value. On import, if a column has mixed data types, the entire column will be cast according to the ImportMixedTypes setting.The default number of rows to be checked is 8. 
ImportMixedTypes	String	Can be set to MajorityType or Text. If set to MajorityType, columns of mixed data types will be cast to the predominant data type on import. If set to Text, columns of mixed data types will be cast to Text on import. The default is Text. 
AppendBlankRows	DWORD	Number of blank rows to be appended to the end of a Microsoft Excel 3.0 or 4.0 worksheet before new data is added. For example, if AppendBlankRows is set to 4, Jet will append four blank rows to the end of the worksheet before appending rows that contain data. Integer values for this setting can range from 0 to 16; the default is 0 (no additional rows appended). 
FirstRowHasNames	Binary	Indicates whether the first row of the table contains column names. A value of 01 indicates that, during import, column names are taken from the first row. A value of 00 indicates that there are no column names in the first row; column names appear as F1, F2, F3, and so on. The default is 01. 
Microsoft Excel ISAM Formats
The Jet\3.0\ISAM Formats\Excel 3.0 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Excel
ExportFilter	String	Microsoft Excel 3 (*.xls)
CanLink	Binary	01
OneTablePerFile	Binary	00
IsamType	DWORD	1
IndexDialog	Binary	00
CreateDBOnExport	Binary	01
ResultTextExport	String	Export data from the current database into a Microsoft Excel 3.0 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\Excel 4.0 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Excel
ExportFilter	String	Microsoft Excel 4 (*.xls)
CanLink	Binary	01
OneTablePerFile	Binary	00
IsamType	DWORD	1
IndexDialog	Binary	00
CreateDBOnExport	Binary	01
ResultTextExport	String	Export data from the current database to a Microsoft Excel 4.0 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\Excel 5.0 folder contains the entries listed in the following table, which apply to Microsoft Excel 5.0 and 7.0.
  
Entry 	Type	Value

Engine	String	Excel
ExportFilter	String	Microsoft Excel 5-7 (*.xls)
ImportFilter	String	Microsoft Excel (*.xls)
CanLink	Binary	01
OneTablePerFile	Binary	00
IsamType	DWORD	1
IndexDialog	Binary	00
CreateDBOnExport	Binary	01
ResultTextImport	String	Import data from the external file into the current database. Changing data in the current database will not change data in the external file.
ResultTextLink	String	Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport	String	Export data from the current database to a Microsoft Excel 5.0 file. This process will overwrite the data if it is exported to an existing file.
Microsoft FoxPro Initialization Settings
The Jet\3.0\Engines\Xbase folder includes initialization settings for the Msxb3032.dll driver, which is used for access to external FoxPro data sources. 
The Microsoft Jet database engine uses the Xbase folder entries listed in the following table.
  
Entry	Type	Description

win32	String	Location of Msxb3032.dll. The full path is determined at the time of installation. 
NetworkAccess	Binary	Binary indicator for file locking preference. If NetworkAccess is set to 00, tables are opened for exclusive access, regardless of the settings of the exclusive argument for the OpenDatabase and OpenRecordset methods. The default value is 01. 
PageTimeout	DWORD	Length of time between when data is placed in an internal cache and when it is invalidated. The value is specified in 100-millisecond units. The default is 600 units, or 60 seconds. 
INFPath	String	Full path to the .inf file folder. The Microsoft Jet database engine first looks for an .inf file in the folder containing the table. If the .inf file isnot in the database folder, the engine looks in the INFPath. If there is no INFPath, it uses whatever index files (.cdx or .mdx) it finds in the database folder. This entry is not written by the installation procedure.
CollatingSequence	String	Collating sequence for all Microsoft FoxPro tables created or opened using Microsoft Jet. Possible values are ASCII and International. The default is ASCII. 
DataCodePage	String	Indicator of how text pages are stored. Possible settings are as follows:OEM = OemToAnsi and AnsiToOem conversions done.ANSI = OemToAnsi and AnsiToOem conversions not done.The default is OEM. 
Deleted	Binary	Binary indicator that determines how records marked for deletion are handled by the Microsoft Jet database engine. A value of 01 corresponds to the Microsoft FoxPro command SET DELETED ON and indicates never to retrieve or position on a deleted record. A value of 00 corresponds to the Microsoft FoxPro command SET DELETED OFF and indicates to treat a deleted record like any other record. The default is 00. 
Century	Binary	Binary indicator for formatting the century component of dates in cases where date-to-string functions are used in index expressions. A value of 01 corresponds to the Microsoft FoxPro command SET CENTURY ON, and a value of 00 corresponds to the Microsoft FoxPro command SET CENTURY OFF. The default is 00. 
Date	String	Date formatting style to use in cases where date-to-string functions are used in index expressions. The possible settings, which correspond to the Microsoft FoxPro SET DATE command, are American, ANSI, British, French, DMY, German, Italian, Japan, MDY, USA, and YMD. The default is MDY. 
Mark	DWORD	Decimal value of the ASCII character used to separate date parts. The default depends on the Date setting as follows:·  "/" (American, MDY)
·  "." (ANSI)
·  "/" (British, French, DMY)
·  "." (German)
·  "-" (Italian)
·  "/" (Japan, YMD)
·  "-" (USA)A value of 0 specifies that the system should use the separator usually associated with the selected date format.The default is 0. 
Exact	Binary	Binary indicator for string comparisons. A value of 01 corresponds to the Microsoft FoxPro command SET EXACT ON. A value of 00 corresponds to the Microsoft FoxPro command SET EXACT OFF. The default is 00. 
Microsoft FoxPro ISAM Formats
The Jet\3.0\ISAM Formats\FoxPro 2.0 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Xbase
ExportFilter	String	Microsoft FoxPro 2.0 (*.dbf)
ImportFilter	String	Microsoft FoxPro (*.dbf)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	01
IndexFilter	String	Microsoft FoxPro Index (*.idx; *.cdx)
CreateDBOnExport	Binary	00
ResultTextImport	String	Import data from the external file into the current database. Changing data in the current database will not change data in the external file.
ResultTextLink	String	Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport	String	Export data from the current database to a Microsoft FoxPro 2.0 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\FoxPro 2.5 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Xbase
ExportFilter	String	Microsoft FoxPro 2.5 (*.dbf)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	01
IndexFilter	String	Microsoft FoxPro Index (*.idx; *.cdx)
CreateDBOnExport	Binary	00
ResultTextExport	String	Export data from the current database to a Microsoft FoxPro 2.5 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\FoxPro 2.6 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Xbase
ExportFilter	String	Microsoft FoxPro 2.6 (*.dbf)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	01
IndexFilter	String	Microsoft FoxPro Index (*.idx; *.cdx)
CreateDBOnExport	Binary	00
ResultTextExport	String	Export data from the current database to a Microsoft FoxPro 2.6 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\FoxPro 3.0 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Xbase
ExportFilter	String	Microsoft FoxPro 3.0 (*.dbf)
CanLink	Binary	00
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	01
CreateDBOnExport	Binary	00
ResultTextExport	String	Export data from the current database to a Microsoft FoxPro 3.0 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\FoxPro 3.0 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Xbase
ExportFilter	String	Microsoft FoxPro 3.0 (*.dbc)
CanLink	Binary	00
OneTablePerFile	Binary	00
IsamType	DWORD	0
IndexDialog	Binary	00
CreateDBOnExport	Binary	00
ResultTextImport	String	Import data from the external file into the current database. Changing data in the current database will not change data in the external file.
dBASE Initialization Settings
The Jet\3.0\Engines\Xbase folder includes initialization settings for the Msxb3032.dll driver, which is used for access to external dBASE data sources.
The Microsoft Jet database engine uses the Xbase folder entries listed in the following table.
  
Entry	Type	Description

win32	String	Location of Msxb3032.dll. The full path is determined at the time of installation. 
NetworkAccess	Binary	Binary indicator for file-locking preference. If NetworkAccess is set to 00, tables are opened for exclusive access, regardless of the settings of the exclusive argument for the OpenDatabase and OpenRecordset methods. The default value is 01. 
PageTimeout	DWORD	Length of time between when data is placed in an internal cache and when it is invalidated. The value is specified in 100-millisecond units. The default is 600 units, or 60 seconds. 
INFPath	String	Full path to the .inf file folder. The Microsoft Jet database engine first looks for an .inf file in the folder containing the table. If the .inf file isn’t in the database folder, the engine looks in the INFPath. If there is no INFPath, it uses whatever index files (.cdx or .mdx) it finds in the database folder. This entry is not written by the installation procedure.
CollatingSequence	String	Collating sequence for all dBASE tables created or opened using Microsoft Jet. Possible values are ASCII and International. The default is ASCII. 
DataCodePage	String	Indicator of how text pages are stored. Possible settings are as follows:OEM = OemToAnsi and AnsiToOem conversions done.ANSI = OemToAnsi and AnsiToOem conversions not done.The default is OEM. 
Deleted	Binary	Binary indicator that determines how records marked for deletion are handled by the Microsoft Jet database engine. A value of 01 corresponds to the dBASE command SET DELETED ON and indicates never to retrieve or position on a deleted record. A value of 00 corresponds to the dBASE command SET DELETED OFF and indicates to treat a deleted record like any other record. The default is 00. 
Century	Binary	Binary indicator for formatting the century component of dates in cases where date-to-string functions are used in index expressions. A value of 01 corresponds to the dBASE command SET CENTURY ON, and a value of 00 corresponds to the dBASE command SET CENTURY OFF. The default is 00. 
Date	String	Date formatting style to use in cases where date-to-string functions are used in index expressions. The possible settings for this entry, which corresponds to the dBASE SET DATE command, are American, ANSI, British, French, DMY, German, Italian, Japan, MDY, USA, and YMD. The default is MDY. 
Mark	DWORD	Decimal value of the ASCII character used to separate date parts. The default depends on the Date setting as follows:·  "/" (American, MDY)
·  "." (ANSI)
·  "/" (British, French, DMY)
·  "." (German)
·  "-" (Italian)
·  "/" (Japan, YMD)
·  "-" (USA)A value of 0 specifies that the system should use the separator usually associated with the selected date format.The default is 0. 
Exact	Binary	Binary indicator for string comparisons. A value of 01 corresponds to the dBASE command SET EXACT ON. A value of 00 corresponds to the dBASE command SET EXACT OFF. The default is 00. 
dBASE ISAM Formats
The Jet\3.0\ISAM Formats\dBASE III folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Xbase
ExportFilter	String	dBASE III (*.dbf)
ImportFilter	String	dBASE III (*.dbf)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	01
IndexFilter	String	dBASE Index (*.ndx)
CreateDBOnExport	Binary	00
ResultTextImport	String	Import data from the external file to the current database. Changing data in the current database will not change data in the external file.
ResultTextLink	String	Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport	String	Export data from the current database to a dBASE III file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\dBASE IV folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Xbase
ExportFilter	String	dBASE IV (*.dbf)
ImportFilter	String	dBASE IV (*.dbf)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	01
IndexFilter	String	dBASE Index (*.ndx; *.mdx)
CreateDBOnExport	Binary	00
ResultTextImport	String	Import data from the external file to the current database. Changing data in the current database will not change data in the external file.
ResultTextLink	String	Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport	String	Export data from the current database to a dBASE IV file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\dBASE 5.x folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Xbase
ExportFilter	String	dBASE 5.0 (*.dbf)
ImportFilter	String	dBASE 5.0 (*.dbf)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	01
IndexFilter	String	dBASE Index (*.ndx; *.mdx)
CreateDBOnExport	Binary	00
ResultTextImport	String	Import data from the external file to the current database. Changing data in the current database will not change data in the external file.
ResultTextLink	String	Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport	String	Export data from the current database to a dBASE 5 file. This process will overwrite the data if it is exported to an existing file.
Paradox Initialization Settings
The Jet\3.0\Engines\Paradox folder includes initialization settings for the Mspx3032.dll driver, which is used for access to external Paradox data.
The Microsoft Jet database engine uses the Paradox folder entries listed in the following table.
  
Entry	Type	Description

win32	String	Location of Mspx3032.dll. The full path is determined at the time of installation. 
PageTimeout	DWORD	Length of time between when data is placed in an internal cache and when it is invalidated. The value is specified in 100-millisecond units. The default is 600 units, or 60 seconds. 
CollatingSequence	String	Collating sequence for all Paradox tables created or opened using Microsoft Jet. Possible values are ASCII, International, Norwegian-Danish, and Swedish-Finnish. The CollatingSequence entry must match the collating sequence used when the Paradox table was built. The default is ASCII. 
DataCodePage	String	Indicator of how text pages are stored. Possible settings are as follows:OEM = OemToAnsi and AnsiToOem conversions done.ANSI = OemToAnsi and AnsiToOem conversions not done.The default is OEM. 
ParadoxUserName	String	Name to be displayed by Paradox if a table is locked by the Paradox ISAM and an interactive user accessing the data from Paradox (rather than from Microsoft Access) attempts to place an incompatible lock. This entry isn’t added if the computer isn’t on a network. Note: If you indicate a ParadoxUserName, you must also specify a ParadoxNetPath and a ParadoxNetStyle or you’ll receive an error when you try to access external Paradox data..
ParadoxNetPath	String	Full path to the folder containing the Paradox.net file (for Paradox 3.x) or the Pdoxusrs.net file (for Paradox 4.x). This entry isn’t added if the computer isn’t on a network. Usually, you need to change the initial setting (added by the Setup program), which is a best guess at where the file might be. The full ParadoxNetPath (including the drive letter) must be consistent for all users sharing a particular database (folder). Note: If you indicate a ParadoxNetPath, you must also specify a ParadoxUserName and a ParadoxNetStyle or you’ll receive an error when you try to access external Paradox data.
ParadoxNetStyle	String	The network access style to use when accessing Paradox data. Possible values are3.x and 4.x.:Paradox 3.x users cannot set this to 4.x; if they do, the driver will use the wrong locking method. Paradox 5.0 users must use the 4.x ParadoxNetStyle setting to ensure proper locking behavior.This entry isn’t added if the computer isn’t on a network. This entry should correspond to whatever version of Paradox the users in the group are using. It must be consistent for all users sharing a particular database (folder). The default is 4.x. Note: If you indicate a ParadoxNetStyle, you must also specify a ParadoxUserName and a ParadoxNetPath or you’ll receive an error when you try to access external Paradox data.
Network Paths for Paradox
When you link or open a Paradox table that resides on a server and is shared by multiple users, you must set the ParadoxNetPath option in the Jet\3.0\Engines\Paradox directory of the Windows registry to the path for either the Paradox.net file (for Paradox 3.x) or the Pdoxusrs.net file (for Paradox 4.x).
  
Important   The ParadoxNetPath, including the drive letter, must be consistent for all users sharing a particular database (folder). For example, if the Paradox.net file is in the Wrkgrp folder on drive Q for one user of the database, it must be in the Wrkgrp folder on drive Q for all other users of the database.
  
Paradox ISAM Formats
The Jet\3.0\ISAM Formats\Paradox 3.x folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Paradox
ExportFilter	String	Paradox 3 (*.db)
ImportFilter	String	Paradox (*.db)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	00
CreateDBOnExport	Binary	00
ResultTextImport	String	Import data from the external file to the current database. Changing data in the current database will not change data in the external file.
ResultTextLink	String	Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport	String	Export data from the current database to a Paradox 3 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\Paradox 4.x folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Paradox
ExportFilter	String	Paradox 4 (*.db)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	00
CreateDBOnExport	Binary	00
ResultTextExport	String	Export data from the current database to a Paradox 4 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\Paradox 5.x folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Paradox
ExportFilter	String	Paradox 5 (*.db)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	0
IndexDialog	Binary	00
CreateDBOnExport	Binary	00
ResultTextExport	String	Export data from the current database to a Paradox 5 file. This process will overwrite the data if it is exported to an existing file.
Lotus Initialization Settings
The Jet\3.0\Engines\Lotus folder includes initialization settings for the Mslt3032.dll driver, which is used for external access to Lotus spreadsheets.
The Microsoft Jet database engine uses the Lotus folder entries listed in the following table.
  
Entry	Type	Description

win32	String	Location of Mslt032.dll. The full path is determined at the time of installation. 
TypeGuessRows	DWORD	Number of rows to be checked for the data type. The data type is determined based on the most frequently found data type in the selection. If there is a tie, the data type is determined in the following order: Number, Currency, Date, Text, Long Text. If data is encountered that does not match the data type guessed for the column, it is returned as a Null value. On import, if a column has mixed data types, the entire column will be converted according to the ImportMixedTypes setting.The default number of rows to be checked is 8. 
ImportMixedTypes	String	Can be set to MajorityType or Text. If set to MajorityType, columns of mixed data types will be cast to the predominant data type on import. If set to Text, columns of mixed data types will be cast to Text on import. The default is Text. 
AppendBlankRows	DWORD	Number of blank rows to be appended to the end of a WK1 worksheet before new data is added. For example, if AppendBlankRows is set to 4, Microsoft Jet will append four blank rows to the end of the worksheet before appending rows that contain data. Integer values for this setting can range from 0 to 16; the default is 0 (no additional rows appended). 
FirstRowHasNames	Binary	Indicates whether the first row of the table contains column names. A value of 01 indicates that, during import, column names are taken from the first row. A value of 00 indicates that there are no column names in the first row; column names appear as F1, F2, F3, and so on. The default is 01. 
Lotus ISAM Formats
The Jet\3.0\ISAM Formats\Lotus WK1 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Lotus
ExportFilter	String	Lotus 1-2-3 WK1 (*.wk1)
ImportFilter	String	Lotus 1-2-3 WK1 (*.wk*)
CanLink	Binary	00
OneTablePerFile	Binary	00
IsamType	DWORD	1
IndexDialog	Binary	00
CreateDBOnExport	Binary	01
ResultTextImport	String	Import data from the external file to the current database. Changing data in the current database will not change data in the external file.
ResultTextExport	String	Export data from the current database to a Lotus 1-2-3 version 2 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\Lotus WK3 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Lotus
ExportFilter	String	Lotus 1-2-3 WK3 (*.wk3)
CanLink	Binary	00
OneTablePerFile	Binary	00
IsamType	DWORD	1
IndexDialog	Binary	00
CreateDBOnExport	Binary	01
ResultTextExport	String	Export data from the current database to a Lotus 1-2-3 version 3 file. This process will overwrite the data if it is exported to an existing file.
The Jet\3.0\ISAM Formats\Lotus WK4 folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Lotus
CanLink	Binary	00
OneTablePerFile	Binary	00
IsamType	DWORD	1
IndexDialog	Binary	00
CreateDBOnExport	Binary	01
Text Data Source Initialization Settings
The Jet\3.0\Engines\Text folder includes initialization settings for the Mstx3032.dll driver, which is used for external access to text data files.
The Microsoft Jet database engine uses the Text folder entries listed in the following table.
  
Entry	Type	Description

win32	String	Location of Mstx3032.dll. The full path is determined at the time of installation. 
MaxScanRows	DWORD	Number of rows to be scanned when guessing the column types. If set to 0, the entire file will be searched. The default is 25. 
FirstRowHas Names	Binary	Indicates whether the first row of the table contains column names. A value of 01 indicates that, during import, column names are taken from the first row. A value of 00 indicates that there are no column names in the first row. The default is 01. 
CharacterSet	String	Indicator of how text pages are stored. Possible settings are as follows:OEM = OemToAnsi and AnsiToOem conversions done.ANSI = OemToAnsi and AnsiToOem conversions not done.The default is OEM. 
Format	String	Can be any of the following: TabDelimited, CSVDelimited, Delimited (<single character >). The single-character delimiter in the Delimited format can be any single character except a double quotation mark ("). The default is CSVDelimited. 
Extensions	String	Extension of whatever files are to be browsed when you’re looking for text-based data. The default is .txt, .csv, .tab, or .asc. 
ExportCurrencySymbols	Binary	Indicates whether the appropriate currency symbol is included when currency fields are exported. A value of 01 indicates that the symbol is included. A value of 00 indicates that only the numeric data is exported. The default is 01. 
Text Data Source ISAM Formats
The Jet\3.0\ISAM Formats\Text folder contains the entries listed in the following table.
  
Entry 	Type	Value

Engine	String	Text
ExportFilter	String	Text Files (*.txt; *.csv; *.tab; *.asc)
ImportFilter	String	Text Files (*.txt; *.csv; *.tab; *.asc)
CanLink	Binary	01
OneTablePerFile	Binary	01
IsamType	DWORD	2
IndexDialog	Binary	00
CreateDBOnExport	Binary	00
ResultTextImport	String	Import data from the external file into the current database. Changing data in the current database will not change data in the external file.
ResultTextLink	String	Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file.
ResultTextExport	String	Export data from the current database to a text file. This process will overwrite the data if it is exported to an existing file.
Microsoft ODBC Driver Initialization Settings
The following section describes initialization settings for the Microsoft ODBC database driver. These registry settings must be added manually; the Setup program does not write default values to the \Hkey_Local_Machine\Software\Microsoft\Access\7.0\Jet\3.0\Engines\ODBC folder.
The \Hkey_Local_Machine\Software\Microsoft\Access\7.0\Jet\3.0\Engines\ODBC folder stores initialization settings for the Microsoft Jet database engine.
The Jet database engine uses the ODBC entries listed in the following table.
  
Entry	Type	Description

LoginTimeout	DWORD	Number of seconds a logon attempt can continue before timing out. The default is 20.
QueryTimeout	DWORD	Number of seconds (total processing time) a query can run before timing out. The default is 60.
ConnectionTimeout	DWORD	Number of seconds a cached connection can remain idle before timing out. The default is 600.
AsyncRetryInterval	DWORD	Number of milliseconds between polls to determine whether the server is finished processing a query. This entry is used only for asynchronous processing.  The default is 500.
AttachCaseSensitive	DWORD	Indicator of whether to match table names exactly when linking. Values are 0 (link the first table matching the specified name, regardless of case) and 1 (link a table only if the name matches exactly). The default is 0.
AttachableObjects	String	List of server object types to which linking will be allowed. The default is: 'TABLE', 'VIEW', 'SYSTEM TABLE', 'ALIAS', 'SYNONYM'.
SnapshotOnly	DWORD	Indicator of whether Recordset objects are forced to be of the snapshot type. Values are 0 (allow dynasets) and 1 (force snapshots only). The default is 0.
TraceSQLMode	DWORD	Indicator of whether the Jet database engine will trace SQL statements sent to an ODBC data source in Sqlout.txt. Values are 0 (no) and 1 (yes). The default is 0. This entry is interchangeable with SQLTraceMode.
TraceODBCAPI	DWORD	Indicator of whether to trace ODBC API calls in Odbcapi.txt. Values are 0 (no) and 1 (yes). The default is 0.
DisableAsync	DWORD	Indicator of whether to force synchronous query execution. Values are 0 (use asynchronous query execution if possible) and 1 (force synchronous query execution). The default is 0..
JetTryAuth	DWORD	Indicator of whether to try using the Microsoft Access user name and password to log on to the server before prompting. Values are 0 (no) and 1 (yes). The default is 1.
PreparedInsert	DWORD	Indicator of whether to use a prepared INSERT statement that inserts data in all columns. Values are 0 (use a custom INSERT statement that inserts only non-Null values) and 1 (use a prepared INSERT statement). The default is 0.Using prepared INSERT statements can cause Nulls to overwrite server defaults and can cause triggers to execute on columns that weren’t inserted explicitly.
PreparedUpdate	DWORD	Indicator of whether to use a prepared UPDATE statement that updates data in all columns. Values are 0 (use a custom UPDATE statement that sets only columns that have changed) and 1 (use a prepared UPDATE statement). The default is 0.Using prepared UPDATE statements can cause triggers to execute on unchanged columns.
FastRequery	DWORD	Indicator of whether to use a prepared SELECT statement for parameterized queries. Values are 0 (no) and 1 (yes). The default is 0.
Microsoft Excel Registry Keys and Values
This section covers the registry keys and values for Microsoft Excel. If you need to change these values, use the Registry Editor (follow the procedure given earlier in this chapter). 
Microsoft Excel Key
The following sections describe the values contained in the Microsoft Excel key.
AltStartup
The AltStartup value is a string that specifies the alternate startup folder. When you start Microsoft Excel, files located in the Xlstart folder are loaded automatically, followed by files located in the alternate startup folder.
AutoCalculate (new for version 7.0)
This value is a DWORD that stores an index to the AutoCalculation function. The values are as listed in the following table.
  
Value	Function	

0	Count Nums	
4	Sum	
5	Average	
6	Min	
7	Max	
169	Count	
AutoFormat and AutoFormat Options
The AutoFormat and AutoFormat Options values are DWORD values that specify the default formatting choice to be used when the AutoFormat toolbar button is clicked.
The AutoFormat value stores an index number that points to a format. The format indexes are numbered 1 through 14, corresponding to the order in which they appear in the list in the AutoFormat dialog box.
The AutoFormat Options value controls which formatting attributes are applied for the format specified in the AutoFormat value. The formatting attributes correspond to the options in the AutoFormat dialog box. The values for the formatting attributes are listed in the following table.
  
AutoFormat option	Indicates	

1	Number	
2	Font	
4	Alignment	
8	Border	
16	Patterns	
32	Width/Height	
For example, if the AutoFormat Options value is 10, the font and border properties of a format are applied. The number 10 is the sum of 2 (font) and 8 (border). The default value for AutoFormat Options is 63 — the sum of all of the numbers — indicating that all of the formatting properties are applied.
AutoDec
Auto Decimal places.
Basics (new for version 7.0)
The Setup program writes a 0 (zero) to this DWORD value, which tells Microsoft Excel to display the What’s New topic the first time you start the application. When you dismiss the What’s New topic, Microsoft Excel writes a 1 to this value, which prevents the What’s New topic from being displayed again.
CFDDELink
The CFDDELink value is a DWORD. If the CFDDELink value is set to 1, Microsoft Excel remembers the last clipboard format used for a successful DDE operation; this is used to reduce the time required for future DDE operations.
Default Chart
The Default Chart value is a string that specifies the name of the default chart format. This value stores the setting from the Chart tab in the Options dialog box. The actual default chart formats are saved as chart sheets in a workbook called Xl5galry.xls, in the Xlstart folder.
DefaultPath
The DefaultPath value is a string that specifies the fully qualified path to the default file location. This value stores the Default File Location setting from the General tab in the Options dialog box.
DefSheets
The DefSheets value is a DWORD that specifies the number of new worksheets in each new workbook. For example, if DefSheets is 1, then when you create a new workbook it will contain one worksheet. This value stores the setting from the General tab in the Options dialog box.
Font
The Font value is a string that stores the default font and font size for new worksheets. For example, to specify that the default font is 10-point Arial, the value would be as follows:
  
Arial,10
  
The font name must be the name of the font spelled exactly as it appears in the Font box on the Font tab in the Format Cells dialog box. The FONT value sets the default font used for the Normal style and for row and column headings.
G1Dft-DemoSpd and G1Dft-HelpType
These two values are DWORD values that correspond to options on the Transition tab in the Options dialog box. 
If G1Dft-HelpType is 0, this indicates that you want Help for Lotus 1-2-3 Users to display a set of instructions. If G1Dft-HelpType is 1, this indicates that you want Help for Lotus 1-2-3 Users to give a demonstration for the Lotus 1-2-3 commands that the user types.
The G1Dft-DemoSpd value controls the speed of the demonstration when the G1Dft-HelpType option is 1. This can be a number from 1 to 5, where 1 is slow and 5 is fast.
Maximized and Pos
The Maximized value is a DWORD that indicates the size of the application window and the size of the workbook window when you start Microsoft Excel. Bit 0 controls the size of the application window, and bit 1 controls the size of the workbook window, as shown in the following table.
  
Maximized	Indicates	

0	Application window size and position are set by the Pos value; workbook window is slightly smaller than the available space.	
1	Application window fills the screen; workbook window is slightly smaller than the available space.	
2	Application window size and position are set by the Pos value; workbook window fills the available space below the toolbars.	
3	Application window fills the screen; workbook window fills the available space below the toolbars.	
The Pos value is a string that contains window coordinates for the application window when it is not maximized. The first two coordinates set the distance from the left and top of the screen to the top-left corner of the window, respectively. The third coordinate is the window width, and the fourth coordinate is the window height. All coordinates are in points.
The following tables show typical values for Maximized and Pos as they would appear in the Registry Editor. In this example, the application window is not maximized and the workbook window is maximized.
  
Name	Data	

Maximized	0x00000002 (2)	
Pos	"28,22,480,321"	
MenuKey
The MenuKey value is a DWORD that indicates the ASCII value corresponding to the character used to activate Microsoft Excel menus or help. The default is the forward slash (/), which corresponds to the menu key for Lotus 1-2-3.. For example, if you changed the menu key on the Transition tab in the Options dialog box to the backslash (\) key, the MenuKey value would be 92.
MoveEnterDir (new for version 7.0)
This value is a DWORD that stores the setting of the Move Selection After Enter Direction option on the Edit tab in the Options dialog box. The values are shown in the following table.
  
Value	Indicates	

0	Down	
1	Right	
2	Up	
3	Left	
MRUFuncs
The MRUFuncs value specifies the functions that appear in the most recently used list in the Function Wizard. The functions are stored as their function index number (iftab). 
OPEN
You can use OPEN string values to specify workbooks that you want opened automatically at startup. The first OPEN name is OPEN, the second is OPEN1, the third is OPEN2, and so on. The OPEN string contains the full path to the file to open, and the filename must be enclosed in double quotation marks. When you view the OPEN value in the Registry Editor, the filename will have two sets of double quotation marks.
The Add-In Manager (the Add-Ins command on the Tools menu) reads and writes OPEN values. For example, when you select the check box to the left of the Analysis ToolPak add-in, Microsoft Excel writes a string in an OPEN value when it quits; this string h is similar to the following:
  
/R "C:\OFFICE95\EXCEL\LIBRARY\ANALYSIS\ANALYS32.XLL"
  
The /R switch is described in the following section.
Option Switches for the OPEN Value
You can use the /R and /F option switches, alone or together, to modify the behavior of the OPEN value. The /R option switch opens the file as read-only. The /F (fast load) option switch places template workbooks in the New dialog box (File menu).
When you install an add-in that contains demand-loaded custom functions, there will be an OPEN value that points to the add-in workbook, and it will contain the /F switch. Demand loading means that when Microsoft Excel starts, it reads only enough information from the add-in workbook file to establish references to the custom functions in the add-in. These functions are added to the list in the Function Wizard and can be entered on a worksheet. However, the add-in is not fully loaded until one of its custom functions is recalculated.
The /F switch is added to the filename string when the name __DemandLoad (the string “DemandLoad” preceded by two underscores) is defined somewhere in the add-in workbook. For more information about add-ins, see the Microsoft Excel Visual Basic for Windows 95 Programmer’s Guide, available from Microsoft Press. You can order any Microsoft Press book by calling Microsoft Press at 1-800-MSPRESS (1-800-677-7377).
Options, Options3, Options5, and Options95
Each of these four values contains 16 flag bits that are expressed as a DWORD in the registry. After a new installation of Microsoft Excel, the Options value does not appear in the registry. When you change one of the default settings stored in the Options value, Microsoft Excel will write the value to the registry. The flag bits are used as shown in the following table.
Options
  
Options	Indicates	

bit 0	Show scroll bars.	
bit 1	Show formula bar.	
bit 2	Show status bar.	
bit 3	(Reserved.)	
bit 4	Use A1-style references.	
bit 5	(Reserved.)	
bit 6	DDE is enabled.	
bits 7 and 8	Apple Macintosh command underlines.	
bits 9–15	(Reserved.)	
Options3
  
Options3	Indicates	

bit 0	(Reserved.)	
bit 1	Alternate navigation keys are on.	
bit 2	Lotus 1-2-3 Help is on.	
bit 3	Cell note indicators are off.	
bit 4	(Reserved.)	
bit 5	Macros are saved in the Personal Macro Workbook.	
bits 6–13	(Reserved.)	
bit 14	Gridlines in new sheets are off.	
bit 15	(Reserved.)	
Options5
  
Options5	Indicates	

bit 0	Tip Wizard is on.	
bit 1	Prompt for Summary Info.	
bit 2	Editing directly in cells is not allowed.	
bit 3	Status bar is visible in full-screen mode.	
bit 4	Formula bar is visible in full-screen mode.	
bit 5	Full-screen mode.	
bit 6	Most recently used file list is not displayed.	
bit 7	Cut, copy, and sort objects with cells.	
bit 8	Tool tips are off.	
bit 9	Small toolbar buttons.	
bit 10	Toolbar autosensing.	
bit 11	Do not move to next cell after ENTER is pressed.	
bit 12	Do not warn before drag-and-drop copy or paste.	
bit 13	Use black-and-white toolbar buttons.	
bit 14	Ask to update automatic links.	
Options95 (new for version 7.0)
  
Options95	Indicates	

bit 0	AutoComplete is on.	
bit 1	Cell animation is on.	
bits 2–15	(Reserved.)	
Randomize
If you want Microsoft Excel to generate a unique set of random numbers each time you use the RAND function, set Randomize to 1.
StickyPtX and StickyPtY
StickyPtX and StickyPtY indicate the preferred location where you want dialog boxes to appear on the screen: They are updated every time you quit Microsoft Excel.
User
The User value is a string that stores the User Name option on the General tab in the Options dialog box.
Summary of the Values in the Microsoft Excel Key
The following table contains a summary list of the values described in this section.
  
Entry	Type	

AltStartup	String	
AutoCalculate	DWORD	
AutoDec		
AutoFormat	DWORD	
AutoFormat Options	DWORD	
CFDDELink	DWORD	
Default Chart	String	
DefaultPath	String	
DefSheets	DWORD	
Font	String	
G1Dft-DemoSpd	DWORD	
G1Dft-HelpType	DWORD	
Maximized	DWORD	
MenuKey	DWORD	
MoveEnterDir	DWORD	
MRUFuncs	String	
OPEN	String	
Options	DWORD	
Options3	DWORD	
Options5	DWORD	
Options95	DWORD	
Pos	String	
Randomize	DWORD	
StickyPtX	DWORD	
StickyPtY	DWORD	
User	String	
Spell Checker Key
The Spell Checker key contains the values listed in the following table.
  
Entry	Type		Description

Custom Dict	String		Path to custom dictionaries (there can be more than one custom dictionary). For Windows NT, all custom dictionaries must be placed in the Msapps\Proof subfolder of your Windows folder. For Windows 95 (with long filename support), all custom dictionaries must be placed in the \Program Files\Microsoft Shared\Proof folder.
Ignore Caps	DWORD		State of the Ignore Caps check box; 1 = checked.
Speller	String		See the following section.
Suggest Always	DWORD		State of the Suggest check box; 1 = checked.
The Speller value is a string that includes two arguments — Country Code and Dictionary Type — separated by a backslash. Country Code specifies the proper spelling tool to use with the corresponding language version of Microsoft Excel. The following table shows the various country codes.
  
Country code	Language	

1030	Danish	
1031	German	
1033	U.S. English	
1034	Spanish	
1036	French	
1040	Italian	
1043	Dutch	
1044	Norwegian	
1054	Swedish	
2057	British English	
2070	Portuguese	
3081	Australian English	
The Dictionary Type argument refers to five possible types of dictionaries that can be used by the speller. Microsoft Excel always uses type 0 (Normal). The five dictionary types are Normal, Concise (subset of Normal), Complete (includes Medical and Legal), Medical, and Legal. 
Init Menus Key
The Init Menus key contains one string value for each menu that is added to a built-in menu bar. Each value name is a unique tag that identifies the added menu. The string has the following form:
  
menu_bar_num,menu_name,menu_position

  
Argument	Description	

menu_bar_num	Number of the built-in menu bar to which you want to add the menu. The menu bars change, depending on the type of sheet that is active in the workbook. The menu bar numbers are as follows:
3  Nil menu bar (no open workbooks)
10 Worksheet, dialog sheet, version 4.0 macro sheet
11 Chart sheet
12 Visual Basic module	
menu_name	Name of the new menu.	
menu_position	Position of the new menu on the menu bar. This may be the name of the menu after which you want to place the new menu, or a number indicating the menu’s position from the left end of the menu bar.	
Init Commands Key
The Init Menus key contains one string value for each command that is added to a menu. Each value name is a unique tag that identifies the added command. The string has the following form:
  
menu_bar_num,menu_name,command_name,macro,
command_position,macro_key,status_text,help_reference

  
Argument	Description	

menu_bar_num	Number of the built-in menu bar to which you want to add the new menu. The menu bars change, depending on the type of sheet that is active in the workbook. The menu bar numbers are as follows:
3  Nil menu bar (no open workbooks)
10 Worksheet, dialog sheet, version 4.0 macro sheet
11 Chart sheet
12 Visual Basic module	
menu_name	Name of the new menu.	
command_name	Name of the new command.	
macro	Reference to a procedure in an add-in workbook. Choosing the command opens the add-in and runs this procedure. The procedure should delete the command added by this registry key and then replace it with a command that runs a procedure that performs the command actions. 	
command_position	Position of the command on the menu. This may be the name of the command after which you want to place the new command, or a number indicating the command’s position on the menu. If omitted, the command appears at the end of the menu. 	
macro_key	Key assigned to the procedure, if any.	
status_text	Message to be displayed in the status bar when the command is selected.	
help_reference	Filename and topic number for a custom Help topic for the command.	
Delete Commands Key
You can use the Delete Commands key to delete commands from built-in menus. The Add-In Manager (Add-Ins command on the Tools menu) reads and writes values in the Delete Commands key. The key contains one string value for each command that is deleted from a menu. Each value name is a unique tag that identifies the deleted command. The string has the following form:
  
menu_bar_num,menu_name,command_position

  
Argument	Description	

menu_bar_num	Number of the built-in menu bar that contains the menu from which you want to delete the command. The menu bars change, depending on the type of sheet that is active in the workbook. The menu bar numbers are as follows:
3  Nil menu bar (no open workbooks)
10 Worksheet, dialog sheet, version 4.0 macro sheet
11 Chart sheet
12 Visual Basic module	
menu_name	Name of the menu.	
command_position	Position of the command on the menu. This may be the name of the command or a number indicating the command’s position on the menu. 	

Caution   Don't delete the Exit command from the File menu unless you’ve created another way to quit Microsoft Excel!

Recent File List Key
The Recent File List key contains a string value for each of the four most recently used files, which are listed at the bottom of the File menu. The list is updated each time the user quits Microsoft Excel. The string values appear in the Registry Editor, as shown in the following table.
  
Value name	Data	

File1	"C:\Accounting\Closing statement.xls"	
File2	"D:\Monthly\January Sales.xls"	
File3	"C:\Office95\Excel\scratch.xls"	
File4	"\\Corp\public\assets\real\1995 depreciation.xls"	
Add-In Manager Key
This key contains one string value for each add-in that the user installed but later disabled. The string value is the full path and filename of the add-in. When an add-in is installed and enabled, the add-in name appears in the Add-Ins dialog box, and the check box to the left of the name is checked. When the user clears the check box, the add-in is considered to be installed but disabled.
Installed and enabled add-ins cause Microsoft Excel to write an OPEN value to the Microsoft Excel key when the program quits (see “Microsoft Excel Key” in the preceding section). If an add-in is installed and disabled, the OPEN value is removed, and then a corresponding string value is written in the Add-In Manager key.
Converters Key
This key contains the description and .dll location of external file converters, such as the Microsoft Multiplan converter. Each value name is a unique tag that identifies the converter, and each string value has the following form:
  
Friendly description,DLL filename and path,search filter

  
Token	Description

Friendly description	Text that appears in the List Files Of Type box in the Open dialog box.
DLL filename and path	Filename and path of the converter DLL. If you omit the path, the .dll file must be in the same folder as Excel.exe.
Search filter	File filter string — for example, *.xl*.
WK? Settings Key
This key contains values that control settings for opening and saving Lotus 1-2-3 files; these values are listed in the following table.
  
Name	Type		Description

AFE	String		Controls whether Transition Formula Entry (AFE) is on. A value of 2 is used as the default, indicating that AFE is turned on only if a macro name exists on the Lotus 1-2-3 worksheet. Otherwise, a value of 1 causes AFE to always be turned on, whereas a value of 0 causes AFE to be never turned on.
Gridlines	String		If Gridlines=1, gridlines are displayed when a Lotus 1-2-3 worksheet is opened. If Gridlines=0, gridlines are not displayed.
Load_Chart_Wnd	String		If Load_Chart_Wnd=1, Lotus 1-2-3 graphs are converted into Microsoft Excel chart sheets. If Load_Chart_Wnd=0, Lotus 1-2-3 graphs are converted into embedded charts.
Monospace	String		If Monospace=1, Lotus 1-2-3 worksheets are displayed in Microsoft Excel using a monospace font (10-point Courier). If Monospace=0, the Normal style is used.
Line Print Key
This key contains values that control settings used in Lotus 1-2-3 macro line printing. These settings are defined using the various Lotus 1-2-3 Worksheet Global Default Printer (/wgdp) commands and are updated in the registry whenever Microsoft Excel encounters a Lotus 1-2-3 Worksheet Global Default Update (/wgdu) command.
The LeftMarg, RightMarg, TopMarg, and BotMarg values are strings that contain the respective margin settings. The data for LeftMarg and RightMarg refers to numbers of characters. While these two values can be from 0 to 1000, a standard page is 80 characters wide. The data for TopMarg and BotMarg refers to numbers of lines. Although these two values can be from 0 to 240, standard 11-inch-high paper can accommodate a maximum of 66 lines. The number of lines on the page is given by the PgLen string value.
The Setup value is equivalent to the Lotus 1-2-3 Worksheet Global Default Printer Settings (/wgdps) command; it specifies the printer setup string.
The Options value contains 6 bits cast to a decimal number, and it is stored as a string. The following table lists the bits used in the Options value.
  
Bit	Lotus 1-2-3 /wgdp command	

0	Wait	
1	Formatted	
2	AutoLf	
3-5	Port (0 through 7)	
The best way to determine the appropriate decimal number to use with the Options value is to construct the binary number first and then convert it to a decimal value. The default value is Options=2 — or, in binary, 0000 0010 — meaning that bit 1 is set but all the others are cleared.
Bits 3, 4, and 5 indicate the setting used by Lotus 1-2-3 to specify the hardware port used for printing. Microsoft Excel interprets this value as a logical port. The default port setting is LPT1:, which corresponds to bits 3, 4, and 5 being equal to 0 (zero). These port settings are listed in the following table.
  
Bits 3–5	Port	

000	LPT1:	
001	COM1:	
010	LPT2:	
011	COM2:	
100	LPT1:	
101	LPT2:	
110	LPT3:	
111	LPT4:	
Note that LPT1: and LPT2: are each represented twice. Either combination of bits can be used; the results will be the same.
Microsoft Office Registry Keys and Values
This section includes the registry keys and values for mail support, WordMail, Notes/FX support, Office Shortcut Bar settings, and template settings. 
Office Mail Support Settings in the Windows Registry
The following section describes the registry values that support Office mail capabilities.
MapiDLL
This key, located in Hkey_Local_Machine\Software\Microsoft\Microsoft Office\95, determines which e-mail system the Office applications use. You can set this key from an .stf file. Change this setting if you upgrade to a new e-mail system.
This key has a single value, DLL32, which is a string that specifies the path of the DLL that provides MAPI support. Some possible settings are given in the following table.
  
Setting	Function

Mapi32.dll (or entry missing from registry)	Support for Microsoft Exchange, provided with Windows 95. Use this setting with any 32-bit simple MAPI or MAPI 1.0-based e-mail system.
Mapivi32.dll	Support for 16-bit VIM mail systems, including cc:Mail and Lotus Notes Mail.
WordMail Support Settings in the Windows Registry
The following section describes the registry values that support Office mail capabilities.
Stationery
The Stationery keyword in Hkey_Current_User\Software\Microsoft\Word\7.0 has the settings shown in the following table. All settings can be modified from an .stf file and must be present for the WordMail Options dialog box to work correctly.
  
Setting	Function

Cfg File Location	Provides the path to the WordMail configuration file.
Default Template	Provides the path to the default template to use for WordMail messages, email.dot.
DlgDefTpl	Records the default template setting made using the WordMail Options dialog box.
Option	Index number of the last template used to compose a message, or the default template Email.lnk in the WordMail folder, if present.
Options
The Wordmail-Path setting under the Options keyword in Hkey_Current_User\Software\Microsoft\Word\7.0 provides the path to the WordMail program folder, a subfolder of the Word folder. This setting can be modified from an .stf file. Other settings in this keyword do not apply to  WordMail. For information about these settings, see “Microsoft Word Registry Keys and Values” later in this appendix.
WordMail
The WordMail keyword in Hkey_Current_User\Software\Microsoft\Word\7.0 provides a Window setting that records the size and position of the WordMail window. This setting is self-registering.
Extensions
Two settings under the Extensions keyword in Hkey_Local_Machine\Software\Microsoft\Exchange\Client provide information that the Microsoft Exchange client needs to run WordMail. These settings are shown in the following table.
  
Setting	Function

Stationery	Provides the version, path, and other information about Station.dll, which provides the WordMail stationery (template).
Wordmail	Provides the version, path, and other information about Wordmail.dll, which provides WordMail capability to the Microsoft Exchange client software.
Other settings in this keyword do not apply to WordMail. For information about these settings, see the Microsoft Exchange documentation.
Notes/FX Support Settings in the Windows Registry
The following settings are provided for Notes/FX support. The Office Setup program enters them automatically. They can be set from an .stf file.
NoteshNote
This setting supports the NoteshNote clipboard format for each Office application, as in the following:
Hkey_Classes_Root\Clsid\<ID>\DataFormats\GetSet\<n> = NoteshNote,-1,1,1
In the above entry, <ID> is the class ID number for the application, and <n> is the next available number.
RequestDataFormats
This setting enables the NoteshNote clipboard format, as in the following:
Hkey_Classes_Root\<Object>\Protocol\StdFileEditing\RequestDataFormats=NoteshNote
In this entry, <Object> is the version-dependent program ID.
Office Shortcut Bar Settings in the Windows Registry
Office 95 no longer uses .ini files. When previous versions of Office are updated, buttons included in Msoffice.ini are migrated to the Old Office toolbar, as described in “Upgrading Previous Versions of Microsoft Office Manager” in Chapter 10. After the upgrade is complete, the older .ini file has no further effect on Office 95.
The following sections describe the keys contained under Office Shortcut Bar in the Windows 95 registry. These settings are all self-registering except for the toolbar root, which is established by Office Setup.
Position
The key Hkey_Current_User\Software\Microsoft\Office Shortcut Bar\Position has subkeys that represent the different coordinates for the Office Shortcut Bar when it is undocked (when the user double-clicks in the title bar). This key is self-registering.
Toolbar Root
The key Hkey_Current_User\Software\Microsoft\Office Shortcut Bar\Toolbar Root contains the path to the root folder for the toolbars. By default, this is the Msoffice\Office\Shortcut Bar folder. This key is set by the Setup program and is not self-registering.
Toolbars
To allow easy addition of applications to the Office Shortcut Bar, the Windows 95 registry contains the folder location for toolbars. Each toolbar is described by a set of values under the Hkey_Current_User\Software\Microsoft\Office Shortcut Bar\Toolbars key.
Each toolbar has the settings listed in the following table.
  
Setting	Values

Default	Not used.
Buttons	Binary data defining the buttons on the toolbar.
Face	String providing the path to a file containing an icon to use for the selector button and the icon number within that file to use. The path can be relative or fully qualified — for example, “msow.exe”, 2
Path	A string providing the path to the underlying folder containing the files and folders to be displayed as buttons on the toolbar. The path can be fully qualified or can contain the special strings [Office] to indicate that the path is rooted below the Msoffice\Office\Shortcut Bar folder.
The value for the Buttons setting is data that has the following format:
  
[RGB][%][button][NULL][%][separator][NULL][%][button2][NULL][NULL]
[Position][Rows][Hidden]

The elements of this data are listed in the following table.
  
Element	Contains

RGB	A 3-byte color value for the toolbar.
%	Either an * for hidden buttons or a space for visible buttons.
buttons	For each button, the exact name of the file it represents, including the .lnk extension for shortcuts.
separator	The \ character, always preceded by a space.
NULL	The ASCII 0 character, which follows each button string. Two NULLs follow the last button string.
Position	A word indicating the position of this toolbar within the list of toolbars. Note that this is in little-endian ordering; to specify position, enter 04 00 as the word value.
Rows	A word indicating the default number of rows for the toolbar when not docked. Rows is optional, the default value is 04 00 (four rows).
Hidden	A word: 01 00 for hidden, 00 00 for visible.
When you add buttons to toolbars or add new toolbars to the Office Shortcut Bar, consider the user’s need for access to the default buttons and toolbars. You might want to make any new toolbars hidden. Users can then turn the toolbar on when they are ready to use its functionality.
To create a new toolbar
 1.	Make sure that the Office Shortcut Bar (Msoffice.exe) is not running: using the right mouse button, click the background of any toolbar, and then click Exit.
 2.	Create a toolbar folder in the file system. The recommended location is under the Toolbar Root folder. The Toolbar Root location is specified in Hkey_Current_User\Software\Microsoft\Office Shortcut Bar\Toolbar Root.
 3.	Add a new key under Hkey_Current_User\Software\Microsoft\Office Shortcut Bar\Toolbars with the same name as your toolbar folder.
 4.	Add the registry values for the toolbar as described earlier in this “Toolbars” section.
 5.	Restart the Office Shortcut Bar.
  
Template Settings in the Windows Registry
The location of the local template directory is specified by Hkey_Current_User\Software\Microsoft\Microsoft Office\95\Filenew\LocalTemplates. The value for this setting is the fully-qualified path to the root template directory on the user’s local system. For information about adding templates and tabs to the New dialog box, see “Supporting Custom Templates” in the Office section of Chapter 12, “Support and Troubleshooting.”
The file types recognized in the New dialog box are specified by Hkey_Local_Machine\Software\Microsoft\Microsoft Office\95\Wrapper\NewTypes. Modify this setting to add extensions for files created by applications other than the Office applications. The value for this setting is a list of extensions separated by semicolons and ending with two semicolons. The default value is:
  
*.doc;*.dot;*.wiz;*.ppt;*.pot;*.pwz;*.mdb;*.xlt;*.xls;*.obd;*.obt;*.obz;;

Important   Be careful to retain any existing settings whenever you modify this key.
  
Ghosting Message Setting for the Answer Wizard
For each Office application, the Answer Wizard pauses and displays a message the first few times the user selects a ghosted Help topic. In ghosted Help topics, the Answer Wizard selects the command or option for the user. After the user has selected six ghosted Help topics, the message is no longer displayed and the ghosting starts without a pause.
To reset the Answer Wizard so that display of the message is restored for a particular Microsoft Office for Windows 95 application, delete the key that’s stored in Hkey_Current_User/Software/Microsoft/Microsoft Office/95/IntelliSearch/application. This key is self-registering. By deleting this key, you also delete the list of the last few questions that the user asked the Answer Wizard.
Microsoft PowerPoint Registry Keys and Values
This section lists registry entries that can be found in the following Registry Editor locaton:
  
HKEY_CURRENT_USER\Software\Microsoft\Office\PowerPoint\7.0
  
The Addins Key
The Addins key contains settings for PowerPoint features that are implemented using add-ins. Note that, unlike most keys, these keys are case-sensitive, and they always appear in all caps.
The Answer Wizard Key
The Answer Wizard key stores the location of the Answer Wizard database files. The value “Database1” is the default. Any additional databases appear as “Database2,” Database3,” and so on. The key’s “Default” value contains the path to the Answer Wizard data file, such as “C:\Office\Powerpnt\powerpnt.aw.”
The AutoClipArt Key
The AutoClipArt key contains the locations of all the clip-art packages that are indexed for use with AutoClipArt. For more information about the ClipArt Gallery, see “ClipArt Gallery Registry Keys” later in this appendix. For more information about AutoClipArt, see “Clip Art in PowerPoint” in Chapter 12, “Support and Troubleshooting.”
The Content Templates Key
This key is used by the AutoContent Wizard. It stores the locations of the templates in the Office\Templates\Presentations folder — for example, “C:\MSOffice\Templates\Presentations\Training.pot.” For more informaton, see “The AutoContent Wizard,” in Chapter 12.
The Design Templates Key
This key is used by the AutoContent Wizard. It stores the locations of the design templates in the Office\Templates\Presentation Designs folder that correspond to the “Professional” and “Contemporary” visual style options in the AutoContent Wizard — for example, “C:\MSOffice\Templates\Presentation Designs\Professional.pot.” 
For more informaton about PowerPoint templates, see Chapter 4, “Microsoft PowerPoint Architecture.”
The DLL Addins Key
The DLL Addins Key contains settings for PowerPoint features that are implemented using DLLs.
The Document Routing Key
The Document Routing Key stores the state of the “Track Status” check box in the Add Routing Slip dialog box (File menu): 1 = Yes, 0 = No.
The OLE Play Options Key
The OLE Play Options key contains the values listed in the following table.
  
Value name	Type		Value

AddImpact	String		“Movie”
AIPlayer	String		“Movie”
AVIFile	String		“Movie,1,1”
LotusMedia	String		“Movie”
LotusSound	String		“Sound”
MIDFile	String		“Sound,1,1”
MPlayer	String		“Movie,1,1”
PlayerFrameClass	String		“Movie”
SoundRec	String		“Sound”
In the values, the first number represents the first OLE verb for Media Player, which is “Play.” The second number is either  1 or 2; 1 means that the object cannot be played across multiple slides. Both numbers are optional. 
The Powerpnt.ini File
Almost all of the settings that used to be controlled using .ini files in previous versions of Windows are now handled by the registry. One of the few remaining .ini files is \Windows\Powerpnt.ini.
The registry’s AVIFile and MIDFile keys are also included in the OLE Play Options section of the \Windows\Powerpnt.ini file, which is necessary to share files with PowerPoint 4.0.
The Options Key
The Options Key contains the values listed in the following table.
  
Name	Type		Description

Always render high-quality 24-bit images	DWORD		1 = Yes, 0 = No.
AlwaysSuggest	DWORD		Suggest words in the Spelling dialog box:
1 = Yes, 0 = No.
AppMaximized	DWORD		1 = Yes, 0 = No.
AutoRegistration	DWORD		1 = Yes, 0 = No.
BackgroundPrint	DWORD		1 = Yes, 0 = No.
Bottom	DWORD		Screen position of application window when not maximized, in pixels.
DocMaximized	DWORD		1 = Yes, 0 = No.
DragAndDrop	DWORD		Allow drag-and-drop text editing 
1 = Yes, 0 = No.
FullTextSearch	DWORD		Save information used for full-text searches:
1 = Yes, 0 = No.
GuidesVisible	DWORD		1 = Yes, 0 = No.
Left	DWORD		Screen position of application window when not maximized, in pixels.
NewSlideDialog	DWORD		Show Slide Layout dialog when inserting new slides: 1 = Yes, 0 = No.
NoEditTime	DWORD		1 = Yes, 0 = No. 1 indicates that total editing time will not be tracked and will show up as 0 minutes in the Properties dialog box. The total editing statistic is also 0 (zero) in files that are saved. The default is 0, except in the German version of PowerPoint.
NoStyledTitleBar	DWORD		Changes the format of text in the PowerPoint title bar: 1 = Not Styled, 0 = Styled. 
Number of Undos	DWORD		Maximum number possible: 150.
Options dialog current tab	DWORD		1 through 4.
Produce 8-bit metafiles	DWORD		1 = Yes, 0 = No. Turning off this option allows metafiles to display better on 24-bit systems.
PromptForAutoShape	DWORD		Not used.
Right	DWORD		Screen position of application window when not maximized, in pixels.
RulersVisible	DWORD		1 = Yes, 0 = No.
Save Text Content Stream	DWORD		Copies all slide text to a Text_Content index stream for use by Find File. Corresponds to the “Save Full Text Search Information” option. 
1 = Yes, 0 = No. 
Share one IME context	DWORD		Not used.
Show Preview	DWORD		Indicates whether the Slide Miniature (View menu) window is visible: 1 = Yes, 0 = No. 
ShowStatusBar	DWORD		1 = Yes, 0 = No.
SizeOfMRUList	DWORD		Most recently used files listed on the File menu; the maximum is nine.
SmartCutPaste	DWORD		1 = Yes, 0 = No.
SmartQuotes	DWORD		1 = Yes, 0 = No.
SSEndOnBlankSlide	DWORD		1 = Yes, 0 = No.
SSMenuButton	DWORD		Show menu button during slide shows:
1 = Yes, 0 = No.
SSRightMouse	DWORD		Display right-click menu during slide shows: 
1 = Yes, 0 = No.
StartupDialog	DWORD		1 = Yes, 0 = No.
StartupDialogDefault	DWORD		Indicates the last setting chosen in the Startup dialog box: 6 = AutoContent Wizard (default), 7 = Template, 	8 = Blank Presentation, 
9 = Open Existing Presentation.
SummaryInfo	DWORD		Display Properties dialog box on save: 
1 = Yes, 0 = No.
TipOfDay	DWORD		1 = Yes, 0 = No.
TipOfDayId	DWORD		ID Number of last Tip of the Day displayed.
Top	DWORD		Screen position of application window when not maximized, in pixels.
True Inline Conversion	DWORD		1 = Yes, 0 = No. Applies only to Far East software versions. Chooses type of IME conversion to be used.
Use Fast OLE Save	DWORD		1 = Yes, 0 = No. 1 results in faster saves but slightly larger file sizes. 
VerticalRuler	DWORD		1 = Yes, 0 = No.
WordSelection	DWORD		1 = Yes, 0 = No.
The PowerPoint Font Substitutions Key
The PowerPoint Font Substitutions key is not used.
The Ttembed.ini File
Almost all of the settings that used to be controlled using .ini files in previous versions of Windows are now handled by the registry. One of the few remaining .ini files is \Windows\Ttembed.ini.
The PowerPoint Font Substitutions key contains a list of default fonts that are shipped with Windows. These are fonts for which substitutions do not need to be made when True Type fonts are embedded in presentations. For example, Arial=0 indicates that Arial is a default Windows font and does not need to be embedded.
The Quick Preview Section Key
The Quick Preview Section key contains the values listed in the following table
  
Name	Type		Description

FirstTime	DWORD		A “What’s New” screen appears the first time PowerPoint is started. This key changes to 0 (zero) after What’s New is first run. Enter any non-zero number to reset.
QuickPreview	String		Filename, such as “Ppvisex.exe.”
You can view the “What’s New” screen at any time by typing what’s new in the Answer Wizard.
The More Info Key
The More Info key keeps track of how many times a message is displayed that explains how to get more information about topics in the Quick Preview window.
The Recent Typeface List Key
The Recent Typeface List key becomes active only after a font is applied; it contains the names of the most recently used typefaces.
The Recent File List Key
The Recent File List key contains a string value for each of the most recently used files, as listed at the bottom of the File menu. The list is updated each time the user quits PowerPoint. The values appear as strings such as [Path]\[Filename1]. The number of entries in the recent file list depends on the SizeOfMRUList setting in the Options key and the number of files opened or created since the initial installation of PowerPoint. The user can specify the size of the MRU list (and thus the setting in the Options key) on the General tab in the Options dialog box.
  
Note   If you want your users to have easy access to particular network locations at the time of installation, use the STF editor to populate the Recent File List and Recent Folder List keys with paths to important folders. For more information about the STF editor, see Chapter 9, “Customizing Client Installations.”
  
The Recent Folder List Key
The Recent Folder List key contains the path and names of the folders most recently used in particular dialog boxes. This key keeps track of folders selected in the Look In drop-down box in the dialog boxes listed in the following table.
  
Dialog box	Menu		Key

Insert Picture	Insert		PictureDir
Insert Movie	Insert		MultimediaDir
Insert Outline	Insert (Slides From Outline command)		OutlineDir
Apply Design Template	Format		TemplateDir
Options, Advanced Tab	Tools		Default (My Documents, if not otherwise specified)
Select Presentation Template	None (click the Other button in the AutoContent Wizard)		ACOtherCurrentDir
The Default key records the path specified in the Default File Location box on the Advanced tab in the Options dialog box. When there is a value for this key (when the user enters a Default File Location in the Options dialog box), the Open and Save As dialog boxes default to the specified location.
The Sound Key
The Sound key contains a list of MS-DOS file extensions indicating valid sound file types. The default is “.wav.”
The Sound Effects Key
The Sound Effects key contains a list of sound effects that are available for use by the Animation Settings command on the Tools menu, along with strings indicating their paths and filenames — for example, “C:\MSOffice\Sounds\drum.wav.” To add sounds, the value name of the new sound must start with a unique number followed by a colon and then the name of the sound — for example, “120:Door Slam.” The name you type for the sound appears in the Sound Effects drop-down box in the Animation Settings dialog box.
The StyleChecker Key
The Style Checker key becomes active only when any Style Checker options are changed. This key contains the values listed in the following table.
  
Name	Type		Description

BodyAddlPuncChr	String		Character, other than a period, that is designated as the preferred end punctuation character for body text.
BodyCase	String		Case selected for body text: 1= Sentence case, 2= lowercase, 3= UPPERCASE, 4= Title Case, 5= tOGGLE cASE.
BodyMaxBullets	String		Maximum number of bullets per slide.
BodyMinFontSize	String		Smallest font size for body text.
BodyPeriods	String		“Remove,” “Add,” or “Ignore” periods in body text.
BulletsMaxLines	String		Maximum lines of text in bulleted items.
CheckBodyMaxBullets	String		Activate checking for number of bullets per slide.
CheckBodyMin
FontSize	String		Activate checking for minimum font size in body text.
CheckBodyStyle	String		Activate checking for case of body text.
CheckBulletsMaxLines	String		Activate checking for maximum lines of text per bullet.
CheckSlideMax
FontNum	String		Activate checking for maximum number of fonts per slide.
CheckTitleMaxLines	String		Activate checking for maximum lines of text per slide title.
CheckTitleMin
FontSize	String		Activate checking for minimum font size for slide title.
CheckTitleStyle	String		Activate checking for case of slide titles.
LargeBlocksOfText	String		Unused.
SlideMaxFontNum	String		Maximum number of fonts per slide.
TextOffSlide	String		Check for text that extends beyond slide borders.
TitleAddlPuncChar	String		Character, other than a period, that is designated as the preferred end punctuation character for slide titles.
TitleCase	String		Case selected for slide titles: 1= Sentence case, 2= lowercase, 3= UPPERCASE, 4= Title Case, 5= tOGGLE cASE.
TitleMaxLines	String		Maximum lines of text in slide titles.
TitleMinFontSize	String		Smallest font size for slide titles.
TitlePeriods	String		“Remove,” “Add,” or “Ignore” periods in slide titles.
The Spelling Key
The Spelling key contains the Speller key, whose value includes two arguments — Country Code and Dictionary Type — separated by a backslash; for example, “1033\Normal.” Country Code specifies the proper spelling tool to use with the corresponding language version of Microsoft PowerPoint. The following table lists the various country codes.
  
Country code	Language	

1030	Danish	
1031	German	
1033	U.S. English	
1034	Spanish	
1036	French	
1040	Italian	
1043	Dutch	
1044	Norwegian	
1054	Swedish	
2057	British English	
2070	Portuguese	
3081	Australian English	
The Dictionary Type argument refers to five possible types of dictionaries that can be used by the speller. The five dictionary types are Normal, Concise (subset of Normal), Complete (includes Medical and Legal), Medical, and Legal. PowerPoint always uses Normal.
The Toolbar Configuration Key
The Toolbar Configuration key contains the values listed in the following table.
  
Name	Type		Description

ColorButtons	DWORD		1 = Yes, 0 = No.
Large Buttons	DWORD		1 = Yes, 0 = No.
Number	DWORD		Indicates the number of custom toolbar configurations created by the user.
StateN	String		Indicates visible toolbars and their positions. One key listed (State1, State2, and so on) for each toolbar not included in the default toolbar configuration.
ToolTips	DWORD		1 = Yes, 0 = No.
The Translators Key
The Translators key contains the description and location of external file converters shipped with PowerPoint, such as the Harvard Graphics converter. Each translator has a separate key, with one of the formats listed in the following table.
  
Name	Description

Extensions	MS-DOS file extension string — for example, “.SHW”
Path	Filename and path of the translator
Title	Text that appears in the List Files Of Type box in the Open dialog box
Translator Type	1 = PowerPoint translator, 0 = non-PowerPoint translator
  
Note   Translator keys pertaining to sharing PowerPoint files between versions are also included in the MS PowerPoint Translators section of the \Windows\Powerpnt.ini file, which is necessary to share files with PowerPoint 4.0.
  
ClipArt Gallery Registry Keys
This section discusses registry entries that can be found in the following Registry Editor path:
  
HKEY_LOCAL_MACHINE\Software\Microsoft\ClipArt Gallery\2.0\
  
The Import Key
When new clip-art packages are installed on the computer (but not installed in the ClipArt Gallery) and registered, they appear under the Import key. Each Import key entry includes a string indicating the location of the ClipArt Gallery file (with the extension .cag) for each ClipArt Gallery category installed for PowerPoint, such as “PowerPoint Popular ClipArt.” These files contain information used by the ClipArt Gallery to locate, index, and display thumbnail sketches of the Picture Store files (with a .pcs extension) used by the ClipArt Gallery. 
The first time it is started, the ClipArt Gallery creates a master database file named artgalry.cag (using the entries listed in the Import key), stores it in the location specified in the 2.0 key’s Database value, and moves entries in the Import key to the Installed key. After the ClipArt Gallery is run for the first time, anything listed in the Import key that is not specifically installed is automatically moved to the Postponed key. The default location for the artgalry.cag file is the Windows folder. The string value for each key is a path to the .cag file, such as in the following example:
  
<Office path>\clipart\pcsfiles\<package name>.CAG

  
Note   In earlier versions of PowerPoint, two files were installed for each clip-art category: an index (.idx) file containing information about the art files, and a “thumbnail” file (.thm) containing thumbnail images of each piece of art. In Office 95, these two files are replaced by a single .cag file. 
Almost all of the settings that used to be controlled using .ini files in previous versions of Windows are now handled by the Windows registry. When installing PowerPoint 7.0 over an earlier version of PowerPoint, the settings stored in the powerpnt.ini file regarding the status of .idx and .thm files are transferred to the registry.
  
The Installed and Postponed Keys
The Import key contains entries when the ClipArt Gallery is started for the first time or when new clip-art packages are installed and registered on the computer. When the Import key contains entries and the ClipArt Gallery is started, the Add New Pictures dialog box appears, listing the items that have not yet been added to the ClipArt Gallery — that is, the items listed in the Import key. When a user selects one or more entries in this list and adds them to the ClipArt Gallery, those entries are moved from the Import key to the Installed key. Any entries not imported are removed from the Import key and placed in the Postponed key. Entries in the Postponed key can be imported by clicking the Organize button in the ClipArt Gallery and then clicking Add Pictures.
The MRUDescription, MRUName, and Settings Keys
These keys, which are related to the ClipArt  Gallery, can be found in the following Registry Editor path:
  
HKEY_CURRENT_USER\Software\Microsoft\ClipArt Gallery\2.0\
  
The Find button in the ClipArt Gallery displays the Find ClipArt dialog box. This dialog box contains edit boxes for name and description, in which a user can enter text to search for clip art with matching names and/or descriptions. The two “MRU” (most recently used) keys store the latest text entries used in these edit boxes. 
The Settings key stores the WindowPos value, indicating the most recent screen position and size coordinates of the ClipArt Gallery application window.
Graphics Filter Registry Keys
The Graphics Filters key stores strings indicating types of graphic import and export filters for all Microsoft Office applications. This key is located in the following path in the registry:
  
HKEY_LOCAL_MACHINE\Software\Microsoft\Shared Tools\Graphics Filters\Import
  
Each key entry includes strings indicating the name, path, and three-character MS-DOS filename extension for the filter. The string values for each key are listed in the following table.
  
Name	Description

Extensions	MS-DOS filename extension string — for example, “.bmp”.
Name	Name of the filter, such as “Windows bitmap”.
Path	The path to the filter, such as “C:\Windows\MSApps\Grphflt\Bmpimp32.Flt”.
Schedule+ Registry Keys and Values
This section describes the registry keys and values for Schedule+ 7.0. 
HKEY_CURRENT_USER Registry Entries
If MAPI is installed and Schedule+ is being used in group-enabled mode, some information about Schedule+ is stored in the Software\Microsoft\Windows Messaging Subsystem\Profiles section of Hkey_Current_User. This information can be modified only by the Schedule+ program itself, not by an administrator or user.

Warning   Changing Schedule+ registry entries in the Hkey_Current_User \Software\Microsoft\Windows Messaging Subsystem\Profiles section of the Windows registry can result in damage to the Schedule+ installation and possible loss of Schedule+ functionality.

This remainder of this section describes Schedule+ registry entries in Hkey_Current_User\Software\Microsoft\Schedule+.
  
Note   Binary values are specified using a DWORD unless otherwise noted.
  
Application Key
  
Entry 	Type	Description

ApptBookLinesColor	Binary	Index to color used to draw the lines in the appointment book.
ArchiveFile	String	Full path of archive file.
BackupFile	String	Full path of backup file.
CoverBitmap	String	Full path to the bitmap file that is displayed on the Cover Page tab.
DefaultPrinter	Binary	Flag to indicate whether the user is printing to the default system printer: 
0 = Not printing to the default system printer. 
1 = Printing to the default system printer.
ExportFile	String	Full path of the Schedule+ export (.sc2) file.
GridAutoFit	Binary	Flag to indicate whether the grid used to display columns of data in the user interface should always automatically fit columns, based on available space.
GridLinesColor	Binary	Index to color used to draw the lines in every grid view.
GridTextColor	Binary	Index to color used to draw the text in every grid view.
InitialAccess	Binary	Determines what the default access for the schedule (.scd) file will be. Applies only to version 7.0.
0 = Read-minimal (default)
1 = No access privileges
2 = Read-only
LocalPath	String	Full path of schedule file; used only if the user is not mail-enabled. If the user is mail-enabled, this information is stored in the Windows Messaging System\Profile section of the registry.
LocalUser	String	Default display name of the user currently logged on. Used to determine the base name of the schedule file when it is first created.
MailDisabled	Binary	Mail-disabled flag. This flag is set to “1” if the user elects not to be mail-enabled in the “Group Enabling” dialog box and never wants to be queried again.
0 = Possibly group enabled
1 = Never group enabled
MessageHideStatus	Binary	Indicates whether the status bar will be shown for Schedule+ meeting forms:
0 = Don’t hide status bar.
1 = Hide status bar.
MessageHideToolbar	Binary	Indicates whether the toolbar will be shown for Schedule+ meeting forms:
0 = Don’t hide toolbar.
1 = Hide toolbar.
NoAutoScan	Binary	Determines whether Schedule+ will scan the user’s Inbox for Schedule+ messages and automatically process them. Applies only if the user is working in group-enabled mode.
0 = Automatically scan inbox for Schedule+ messages.
1 = Don’t scan inbox for Schedule+ messages.
NoScaleCoverBitmap	Binary	Determines whether or not the Cover Page bitmap is scaled to fit the window:
0 = Scale to fit window.
1 = Don’t scale to fit window.
NoStatusBar	Binary	Indicates whether Schedule+ should not show the status bar for opened schedules.
NoToolbar	Binary	Indicates whether Schedule+ should not show the toolbar for opened schedules.
OptionsFilePath	String	Full path to the user options (.vue) file. If no value is specified, the user options file is created in the Windows folder.
OptionsTab	Binary	Indicates which tab was active in the Options dialog box when the user clicked OK.
ReminderToTop	Binary	Interval to bring popped-up reminders to the top, in minutes. If not specified, the default value is 5 minutes. The range is from 0 to 60 minutes.
ShowRecurInstances	Binary	Number of instances of recurring objects to show. The range is from 1 to 32.
SyncStartIdle	Binary	Length of idle time (in hundredths of a second) before the synchronization routine starts. The default value is 6000, or 60 seconds.
TentativeApptColor	Binary	Index of color used as background for tentative appointments in appointment views.
UpdateCover	Binary	Indicates how often to update the Cover Page bitmap, in minutes. If this entry is not present, the default is 120 minutes.
Custom Menus Key
Adds menu items to the Schedule+ user interface. The general form of an add menu entry is as follows:
  
version;menu;new_menu_item;reserved;command_string;help_file;help_id

The fields are listed and described in the following table.
  
Field	Description

Version	Identifies the version of Schedule+ with which the command is compatible; 7.0 is the current version.
Menu	Specifies the menu and the location on the menu where the new menu item is to be placed. The new item is placed just above the existing one on the menu. Provide the menu name, the submenu (if appropriate), and the menu item, separated by commas. The name is case insensitive, and ampersands are ignored. To specify an absolute menu position, use ‘#’ followed by the number for the position. If -1 is specified for the position, the new menu will be added at the end of the menu specified.
New Menu Item	Menu name to be added to the menu bar. Include an ampersand just before the letter that is to serve as an ALT+key accelerator. If no name is provided, a separator is added to the menu.
Reserved	This position is reserved for future use.
Command String	Command string used to call WinExec. If no command string is provided, a new popup menu is added.
Status Bar Text	Text string shown in the status bar when the menu item is selected.
Help File	Windows Help file to be invoked when the user presses F1 while the command is selected. Passed to the Windows Help program.
Help ID	Passed to the Windows Help program along with the Help filename. Use -1 (Help file index) if there is no specific entry in the Help file for this command.
Custom Popup Menus Key
Adds entries to one of the context menus that appear when a user clicks with the secondary mouse button on an area of the user interface. Follows the format described in the preceding section. The menu field can have one of the following values: edit, appts, events, tabs, toolbar, tasks, projects, contacts, columns, or navigator.
Deleted Menus Key
Deletes menu items from the Schedule+ user interface. The general form is as follows:
  
version;menu 

The fields are described in the following table.
  
Field	Description

Version	Identifies the version of Schedule+; 7.0 is the current version.
Menu	Specifies the menu and the location on the menu of the item to delete. Provide the menu name, the submenu (if appropriate), and the menu item, separated by commas. The name is case insensitive, and ampersands are ignored. To specify an absolute menu position, use ‘#’ followed by the number for the position.
Deleted Popup Menus Key
Deletes an entry from a context-sensitive pop-up menu. The format is the same as that described in the preceding section.
Meeting Wizard Key
  
Entry	Type	Description

AskLocation	Binary	Indicates whether Schedule+ will prompt the user to select locations for the meeting.
AskOptional	Binary	Indicates whether Schedule+ will prompt the user to select optional attendees for the meeting.
AskRequired	Binary	Indicates whether Schedule+ will prompt the user to select required attendees for the meeting.
AskResource	Binary	Indicates whether Schedule+ will prompt the user to select resources for the meeting.
Duration	Binary	Length of the meeting, in minutes. The valid range is from one minute to one day minus one minute.
IncludeOptional	Binary	Indicates whether Schedule+ should check the free time of optional attendees:  “0” means don’t check optional attendees’ free time; “1” means check optional attendees’ free time.
Locations	String	List of locations that will be used when the meeting wizard is run. Locations in the list are separated by semicolons. The list of locations from the previous run of the meeting wizard are saved here.
MeetAfter	Binary	Time of the day where Schedule+ begins searching for a valid meeting time. The valid range is from 0 minutes to 1439 minutes (11:59 P.M.). Default value is the user’s start-of-day preference.
MeetBefore	Binary	Time of the day when Schedule+ stops searching for a valid meeting time. The valid range is from 0 minutes to 1439 minutes (11:59 P.M.). The default value is the user’s end-of-day preference.
Optional	String	List of optional attendees that will be used when the meeting wizard is run. Attendees in the list are separated by semicolons. The list of optional attendees from the previous run of the meeting wizard are saved in this location.
Required	String	List of required attendees that will be used when the meeting wizard is run. Attendees in the list are separated by semicolons. The list of required attendees from the previous run of the meeting wizard are saved here.
Resources	String	List of resources that will be used when the meeting wizard is run. Resources in the list are separated by semicolons. The list of resources from the previous run of the meeting wizard is saved in this location.
TravelFrom	Binary	Length of time allotted to travel from the meeting after the meeting has finished. The valid range is from 0 minutes to 99 minutes. The default is 0 minutes.
TravelTo	Binary	Length of time allotted to travel to the meeting. The valid range is from 0 minutes to 99 minutes. The default is 5 minutes.
ValidDays	String	Specifies which days to search for a valid meeting time. The string consists of 1’s and 0’s (zeros); 1 specifies a valid meeting day. Sunday is the first day in the string, followed by Monday, and so on.
Microsoft Schedule+ Key
This registry key is not used by Schedule+ 7.0.
Text Export Wizard Key
  
Entry	Type	Description

Appt Fields	String	Comma-separated string giving the number of each of the exported Schedule+ appointment fields.
Event Fields	String	Comma-separated string giving the number of each of the exported Schedule+ event fields.
Contact Fields	String	Comma-separated string giving the number of each of the exported Schedule+ contact fields.
Filename	String	Name of the export file. 
Default: <Windows directory>\Desktop\Export.csv.
NoFieldNames	Binary	Flag to indicate whether the data is to be exported with field names. Default: 0. Possible values: 0 - 3 (Appts, Tasks, Events, Contacts).
QualifierChar	Binary	ASCII value of string delimiter character + 1. The + 1 is necessary to distinguish a NULL delimiter. 
Default: quotation mark + 1 (0x00000023, 35 decimal).
SeparatorChar		ASCII value of field separator character. 
Default: comma (0x0000002C, 44 decimal).
SingleLine	Binary	Indicates whether export fields containing strings can have carriage-return and line-feed characters. If this flag is set to 1, string fields spanning multiple lines are truncated at the end of the first line during the exporting.
Task Fields	String	Comma-separated string giving the number of each of the exported Schedule+ task fields.
Type	Binary	Index of the radio button for the default export type. 
Default: 0. Possible values: 0 - 3 (Appts, Tasks, Events, Contacts).
Text Import Wizard Key
The registry entries for this key are the same as those for the Text Export Wizard key.
Watch Wizard Key
AlarmData1 through AlarmData5
Encoded information about each alarm. Type: String-encoded ULONG. The formats for Alarm On are listed in the following table.
  
Position in ULONG	Meaning

26-27	Type
21-25	Hour
15-20	Minute
10-14	Day of monthly reminder
5-9	Month of yearly reminder
0-4	Day of yearly reminder
The formats for Alarm Off are listed in the following table.
  
Position in ULONG	Meaning

11-12	Type
6-10	Hour
0-5	Minute
The formats for Alarm Type are listed in the following table.
  
Position in ULONG	Meaning

0	Daily
1	Monthly
2	Yearly
ApptsDays
Number of days of appointments to export. Type: Binary. Default: 7.
ApptsReminderAmt
Number of minutes before the appointment to ring the watch alarm. Type: Binary. Default: 2.
TasksDays
Number of days of tasks to export. Type: Binary. Default: 7.
TasksPriority
Indicates minimum task priority for tasks to be downloaded. Type: Binary. Possible values are as follows: the high byte of the word is ASCII code for one of SPACE, ‘A’, ‘B’, ‘C’, ‘D’, ‘E’, or ‘F’; the low byte of the word is ASCII code for one of the 10 digits.
TmzIndex0
Primary time zone. Type: String-encoded integer. Possible values: 0–51. For a mapping of indexes to time zone names, see the Time Zone tab in the Schedule+ Options dialog box.
TmzIndex1
Secondary time zone. Type: String-encoded integer. Possible values: 0–51.
WatchFlags
Control flags for radio buttons and check boxes in the Watch Wizard. Type: String-encoded WORD. These flags are listed in the following table.
  
Position in WORD	Label	Values

0	UserModified	1 – This word exists because the user has used the wizard before.
1	ApptsAtLeast	1 – Send at least as many as N days of the appointment.
0 – Send exactly N days of the appointment.
2	ApptsTentative	1 – Send tentative appointments. 
0 – Do not send tentative appointments.
3	ApptsReminder	1 – Ring an alarm before each appointment.
4	TasksAll	1 – Send all tasks. 
0 – Send filtered set of tasks.
5	TmzDefault	1 – Use the system time zone setting for a watch.
6	Tmz24Hr0	1 – Time zone 0 is in 24-hour format.
7	Tmz24Hr1	1 – Time zone 1 is in 24-hour format.
8	Alarm1	1 – Alarm 1 is enabled.
9	Alarm2	1 – Alarm 2 is enabled.
10	Alarm3	1 – Alarm 3 is enabled.
11	Alarm4	1 – Alarm 4 is enabled.
12	Alarm5	1 – Alarm 5 is enabled.
13	ApptsLocation	1 – Download the meeting location with appointment text.
WatchFormsWanted
Flag set for which panes of the wizard to display. Type: String-encoded WORD. These flags are listed in the following table.
  
Position in WORD	Label	Value

0	All	1 – Show all panes.
1	Appts		1 – Show the Appointments pane(s).
2	Tasks		1 – Show the Task pane(s).
3	Phone		1 – Show the contact phone numer pane.
4	Anniv	1 – Show the contact anniversary pane.
5	Alarms	1 – Show the alarm pane.
HKEY_LOCAL_MACHINE Registry Entries
The following information about Schedule+ is found in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Schedule+\Application.
Application Key
  
Entry	Type	Description

AppPath	String	Path to the Schedule+ executable files on the local machine.
CDPath	String	Path to Schedule+ DLLs. The installation path may be different if installed from CD-ROM.
DefaultLocalPath	String	Path pointing to where new schedules files will be created.
DemosEnabled	Binary	Indicates whether to show the Microsoft Schedule+ Demos menu item.
FormsRegistered	Binary	Indicates whether the Schedule+ message forms have been registered with the MAPI Forms Registry.
GrayShade	Binary	Makes the level of gray shading for printing lighter or darker. Default value: 230. Possible values: 0 to 255.
LocalPrintFileDir	String	Points to the path where the application can find .prt and .fmt files for printing. If this entry is not present, the default is CDPath.
MailPath	String	Location of Exchange mail client.
MAPIPresent	Binary	Indicates whether or not Schedule+ brings up the Group Enabling dialog box at startup time. If this flag is 0 and MAPI is detected, the user is queried about being group-enabled.
OfficeInstalled	Binary	Set to 1 if Office for Windows 95 is installed; set to 0 if it is not. If this flag is 1, Schedule+ attempts to load the Office 95 DLLs for Office-specific features such as the Answer Wizard.
PrimaryServer	Binary	Indicates whether the user wishes to work primarily with the server copy of the schedule.
ScheduleFinders	String	Identifies the DLLs to load to find server schedules for any user. Multiple DLLs can be specified if they are separated by a space. Schedule+ automatically appends “32.dll” at the end of each entry when searching for the DLL.
ScheduleInterfaces	String	Identifies which DLLs to load to provide the interface between the application and schedule storage. Multiple DLLs can be specified if they are separated by a space. Schedule+ automatically appends a “32.dll” at the end of each entry when searching for the DLL.
ServerPath 	String	Identifies the server where files for the file mstrs32.dll can be found.
TimexWatchInterface	String	Identifies which DLL to load for the Timex Data Link watch Export Wizard. Schedule+ automatically appends a “32.dll” at the end of the entry when searching for the DLL.
WatchInstalled	Binary	Indicates whether the software drivers for exporting to the Timex Data Link watch are installed.
Microsoft Word Registry Keys and Values
This section describes the registry keys and values for Word 7.0. 
Data Key
Settings
The binary value that stores the Winword.opt file information in binary format.
Help Key
Files
The string values that store the locations and filenames for various Word Help files.
  
Value	Description	

Winword.hlp	Word’s primary Help file	
Wphelp.hlp	Help for WordPerfect users upgrading to Word	
Wrdbasic.hlp	Help for users working with WordBasic	
Options Key
  
Entry	Type	Description

Autosave-Path	String	Default folder in which Word locates the temporary files it automatically saves. The default refers to the folder referenced by the TEMP environment variable.
AutoSpell	Integer	Specifies whether to use background spell checking:
0 = Do not use background spell checking.
1 = Use background spell checking.
Picture-Path	String	Default folder where the clip-art pictures supplied with Word are located. The default refers to the Clipart folder where Word was installed — for example, C:\Office95\Clipart.
NoEditTime	Integer	One document property that Word can track is Total Editing Time. This appears on the Statistics tab in the Properties dialog box (File menu, Properties command).
0 = Track editing time.
1 = Do not track editing time.
Programdir 	String	Folder in which the Word executable program is located — for example, C:\Office95\Winword.
Startup-Path	String	Startup folder used by Word. The default refers to the Startup folder where Word was installed — for example, C:\Office95\Winword\Startup.
StartWhatIsNew	Integer	Indicates whether Word will automatically start the “What’s New in Word 95” online demo when Word is first started. Be default, Word starts this online demo only once.
0 = Word will not start the online demo.
1 = Word will start the online demo.
Tools-Path	String	Default folder where Word tools (such as dictionaries) are located. The default for Tools-Path refers to the folder where Word was installed — for example, C:\Office95\Winword.
Wordmail-Path	String	Default folder where files needed to use Word as an e-mail editor are located.
WPHelp	Integer	Specifies whether to use WordPerfect commands.
0 = Do not use WordPerfect commands.
1 = Use WordPerfect commands.
Proofing Tools Key
  
Entry	Type	Description

Grammar\language\
Normal\Dictionary	String	Names the dictionary for a given language and grammar-checking engine.
Grammar\language\
Normal\Engine	String	Names the DLL for a given language and grammar-checking engine.
Hyphenate\language\
Normal\Dictionary	String	Names the dictionary for a given language and hyphenation engine.
Hyphenate\language\
Normal\Engine	String	Names the DLL for a given language and hyphenation engine
Stationery Key
  
Entry	Type	Description

Cfg File Location	String	Applies when using Word as an e-mail editor (WordMail). Specifies the folder where WordMail configuration files are located.
Default Template	String	Applies when using Word as an e-mail editor (WordMail). Specifies the Word template to use for WordMail.
Text Converters Key
  
Entry	Type	Description

Export\converter export classname\Name	String	Name of the export text converter.
Export\converter export classname\Path	String	Location of the export text converter.
Export\converter export classname\Extensions	String	Lists the extensions for document files supported by this export text converter. Extensions are space-separated and not preceded by a period.
Import\converter import classname\Name	String	Name of the import text converter.
Import\converter import classname\Path	String	Location of the import text converter.
Import\converter import classname\Extensions	String	List of the extensions for document files supported by this import text converter. Extensions are space-separated and not preceded by a period.
Find Fast Registry Keys and Values
The following registry entries apply to the Find Fast utility. You can edit most values directly in the Registry Editor, or through the Find Fast control panel.
95\Index List\Index nn
  
Entry	Type	Description

Automatic	Binary	Specifies whether the current index should be automatically updated. The value is in binary format, followed by a decimal value enclosed in parentheses.
0 = Index will not be updated automatically.
1 = Index will be updated automatically.
Folder	String	Drive and folder (including all subfolders) indexed in the current index key.
Index Operation	Integer	Specifies the updating option of the current index. The value is in binary format, followed by a decimal value enclosed in parentheses.
1 = Create the index.
2 = Update the index one time only.
3 = Update the index continuously.
LogFilePath	String	Path to the hidden log file maintained by Find Fast — for example, C:\Windows\System\Ffastlog.txt.
Size Limit	Binary	Limits the maximum size of the current index. The value is in binary format, followed by a decimal value enclosed in parentheses. The decimal value represents bytes.
Proximity Search	Integer	Specifies whether the current index should support faster phrase or proximity searching. When proximity searching is enabled, entire phrases and quoted strings are included in the index. Enabling proximity searching greatly increases the size of the index file. When proximity searching is disabled, the Find Fast utility can accomplish the same searches, but they will take longer.
0 = Proximity searching is disabled.
1 = Proximity searching is enabled.
Type	Integer	Specifies the type of documents indexed in the current index The value is in binary format, followed by a decimal value enclosed in parentheses.0 = Microsoft Office documents
1 = Microsoft Word documents
2 = Microsoft Excel documents
3 = Microsoft PowerPoint documents
4 = Microsoft Project documents
5 = All indexable file types (excludes .exe, and so on)