February 17, 2001

.NET and the Revenge of VB

Few programmers have ever consideredVisual Basic as a real object-oriented programming language, for example becauseof its lack of constructors and inheritance. VB6 code can’t access some Win32 and COM’s features

DeleteFileAssociation – Unregister a file extension

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

SetVBASetting – Modify one of the VBA code editor settings

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)’