February 17, 2001

Private Declare Sub SHChangeNotify Lib “shell32.dll” (ByVal wEventId As Long, _ ByVal uFlags As Long, ByVal dwItem1 As Long, ByVal dwItem2 As Long)Const SHCNE_ASSOCCHANGED = &H8000000Const SHCNF_IDLIST = 0′ Create

‘ Add or remove a program to the list of applications that will’ be automatically launched when Windows boots.” Action can be:’ 0 = delete from list’ 1 = execute

Private Declare Sub SHChangeNotify Lib “shell32.dll” (ByVal wEventId As Long, _ ByVal uFlags As Long, ByVal dwItem1 As Long, ByVal dwItem2 As Long)Const SHCNE_ASSOCCHANGED = &H8000000Const SHCNF_IDLIST = 0′ Destroy

‘ get the description of a file from the registry’ or a null string if the file’s extension isn’t registered” NOTE: requires the GetRegistrtValue functionFunction GetFileDescriptionFromReg(ByVal FileName As String) As

Const HKEY_LOCAL_MACHINE = &H80000002′ modify the value of a setting for the VBA editor from the Registry” Possible values for SettingName are:’ AutoQuickTips2 (0/1)’ AutoStatement2 (0/1)’ AutoValueTips2 (0/1)’ BackGroundCompile (0/1)’

Const HKEY_LOCAL_MACHINE = &H80000002′ read the value of a setting for the VBA editor from the Registry” Possible values for SettingName are:’ AutoQuickTips2 (0/1)’ AutoStatement2 (0/1)’ AutoValueTips2 (0/1)’ BackGroundCompile (0/1)’