ES_StableIF97_AddIn Registry

Registration of ES_StableIF97_AddIn to MS Windows registry is automatically done in software installation process.   However, one modification work by user is required.  That is, the suffix number of Automation AddIn registry string name of "OPEN".   For details, please refer to the explanation below.

ES_StableIF97 AddIn can be used in MS Excel 2013, too.   Only change is Automation Registry directory of "Office / 15.0".

In order to make ES_StableIF97_AddIn software worked correctly in MS Excel, required is registration of ES_StableIF97_AddIn to MS Windows registry.   There are two kinds of registration.   One is Automation AddIn registration and the other is COM AddIn registration.

COM AddIn registration is to make ES_StableIF97_AddIn menus responded to user's click.   Automation AddIn registration is to make ES_StableIF97_AddIn functions worked in Excel.   For reference, even if COM AddIn registration is not working so that ES_StableIF97_AddIn menus do not respond, ES_StableIF97_AddIn functions work in Excel if Automation AddIn registration has been done correctly.  This means that COM AddIn registration and Automation AddIn registration are independent.

These two kinds of registration are done automatically by ES_StableIF97_AddIn software installer.   However, in order to know what is written in the registry and how to modify the registry, User is recommended to read this page.

 

Automation AddIn Registration

1) Clicks Windows [Start] > [Run] menu and input "regedit" into [Open] text box.  Then clicks [OK] button that opens Registry Edit window.

2) Open HKEY_CURRENT_USER / Software / Microsoft / Office / 12.0 / Excel / Options directory in Registry Edit window.   MS Excel 2007 is Office / 12.0, while Excel 2003 and 2002 are Office / 11.0 and Office / 10.0 respectively.  Further, Excel 2010 is Office / 14.0 and Excel 2013 is Office / 15.0.

3) Create a [New Value #1] of Category "REG_SZ" by clicking [New] > [String] in the pop-up window popped up by clicking right mouse button in the right pane.

4) Change the name of the [New Value #1] to "OPEN" by selecting [Change Name] in the pop-up window popped up by clicking right mouse button in the right pane.   If any "OPEN" strings exist already for automation addins of other software, then add a serial number suffixed to the name of "OPEN", such as "OPEN1", "OPEN2", etc..  

When ES_StableIF97_AddIn software is installed for the first time, the automation addin string is named as "OPEN999" automatically by the software installer.   User must modify the "OPEN999" string name to appropriate name having continuous suffix number as explained above.    For example, if "OPEN" and "OPEN1" exist already, use "OPEN2" for ES_StableIF97_AddIn.    

5) Input Data value of the new "OPEN" string to "ES_StableIF97AddIn.StableAddIn" by clicking [Modify(M)] in the pop-up window, as shown in the picture below..

 

COM AddIn Registration

1) Clicks Windows [Start] > [Run] menu and input "regedit" into [Open] text box.  Then clicks [OK] button that opens Registry Edit window.

2) Open HKEY_CURRENT_USER / Software / Microsoft / Office / Excel / Addins directory in Registry Edit window.

3) Open the pop-up window by clicking right mouse button in the right pane of Registry Edit window Addins and select [New] > [Key].  Then a [New Key #1] is created in the left pane of the Registry Edit window.

4) Change the name of the [New Key #1] to "ES_StableIF97AddIn.dsrStableAddIn" by selecting [Change Name] in the pop-up window popped up by clicking right mouse button in the right pane.

5) When open the ES_StableIF97AddIn.dsrStableAddIn folder, a (Default Value) exists already.   Remain the (Default Value) and input new values as shown in the picture below.

Category "REG_SZ" can be created by clicking [New] > [String] in the pop-up window popped up by clicking right mouse button in the right pane, and [DWORD Value(D)] for "REG_DWORD".

Name can be changed by clicking [Change Name] in the pop-up window popped up by clicking right mouse button on the Name and Data value can be changed by clicking [Modify(M)] in the pop-up window.

COM AddIn is finished by this.

Note)  Please note that LoadBehavior of "3" represents "Load on Startup" and "9" represents "Load on Demand".    "Load on Startup" means that the COM AddIn starts when Excel starts.   "Load on Demand" means that the COM AddIn starts when the AddIn is once called.   In order to use ES_StableIF97_AddIn in Visual Basic Application(VBA), the LoadBehavior should be set at "3".   If LoadBehavior is set at "9" and VBA code is executed before the COM AddIn is loaded by once calling, an error of "Instance can not be found" occurs.

 For use in all cases without problem, the "LoadBehavior" value should be set at "3".

 


Copyright (c) : ENGSoft Inc., Seoul, Korea, All right reserved since 2008.  / www.engsoft.co.kr