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.
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 cells. For reference, even if COM AddIn registration is not correct and so ES_StableIF97_AddIn menus do not respond, ES_StableIF97_AddIn functions work in Excel cells if Automation AddIn registration is done correctly. This means that COM AddIn registration and Automation AddIn registration work independently.
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.
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.
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, add a serial number suffixed to the name of "OPEN".
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..
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