_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ _/ _/ Name of the software :Calendar Class Add-in for English (Ver1.20) _/ Kind of the software :FREEWARE _/ Development environment :Windows98SE & Excel2002SP2/2000SR1/97SR1 _/ Environment of operation :Excel97 or later _/ Developer :Keiichi Tsunoda< addinbox@h4.dion.ne.jp > _/　 < http://addinbox.sakura.ne.jp/Bpca_PasteCal_E.htm > _/　 < Old Site http://www.h3.dion.ne.jp/~sakatsu/Bpca_PasteCal_E.htm > _/ Exemption from _/ responsibility :About any damage generated by having used this software, _/ the author shall not take any responsibility. _/ Redistribution :Redistribution conditions are indicated in this document. _/　Reprint :If you would like to do, please let me know. _/　History :3rd Jun. 2005 Ver1.11 _/　 :14th Jun. 2005 Ver1.20 _/ _/　Etc :As for this software virus check has been done with _/ Trend Micro Virus Buster2005. _/ _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ---------------------------------------------------------------------------- << How To Use >> -- Available the Add-In -- 　 1. Extract the distribution file on your PC. a) ReadMe.txt (This text file ) b) ktClsPasteCal.xla (Add-In Workbook for Excel2000 or later) c) ktClsPasteCal_Demo.xls (Demonstration Workbook for Excel2000 or later) d) ktClsPasteCal97.xla (Add-In Workbook for Excel97 or later) e) ktClsPasteCal97_Demo.xls (Demonstration Workbook for Excel97 or later) f) Bpca_PasteCal_E.htm (Help document) g) GifImg (Folder which stored the picture of HTML document) 　　2. Save [ktClsPasteCal.xla] or [ktClsPasteCal97.xla] to your Addin Directory(*1). -- Refer to [ktClsPasteCal.xla ] or [ktClsPasteCal97.xla] from the workbook which you would like to use it. -- 3. Open the workbook which you would like to use these functions. 4. At Visual Basic Editor, Select [Toos > References...] on the Main Toolbar. 5. Check [ktClsPasteCal.xla] or [ktClsPasteCal97.xla] on from Available references dialogue box. 6. Please use [ktClsPasteCalAddin.xla], when you do not use by Excel97. (All PC are Excel2000 or later.) Please use [ktClsPasteCal97.xla], when you use by Excel97, or in using Excel97 and Excel2000 or later. (*1)About Addin Directory This is a directory which is selected as default one when you save file as an Add-In(.xla) on 'Save As' dialogue box. Assume you are Windows98/EXCEL2000 user, typical Dir locations are: C:\Windows\Application Data\Microsoft\AddIns C:\Program Files\Microsoft Office\Office\Library ---------------------------------------------------------------------------- << Special Features >> (1) Two styles of MonthView and DTPicker are supported. (2) A day of the week is supported by two arrangement, "Sun, Mon to Sat" and "Mon to Sat, Sun". (3) A public holiday, year ends and New Year holidays / anniversary of the founding, etc. prepare a holiday list, and registers it into a class. (In a Japanese version, a public holiday of Japan is automatic calculation) These dates are displayed in red and a holiday name is displayed on [ControlTipText]. The creation tool of a holiday list is prepared for the add-in. Execution is also possible from a demonstration book. (4) The date input operation is the [one click input] by the emphasis display of a mouse position. [ MonthView style ] Please prepare the frame of [ Width=108 , Height=105 ]. YEAR moves with a left side SpinButton, and MONTH moves with a right side spin button. The "day" of a mouse position becomes an emphasis display, and a "Click event" occurs by click. A selection date (it is acquirable with a Value property) is displayed on the lower right. (Movement of a year / a month cancels a selection date) [ DTPicker style ] Please prepare the frame of [ Width=108 , Height=20 ]. The margin of [ Height=105 ] is needed under a frame. (If a calendar carries out a drops down, it will change to [ Height=125 ].) You may arrange other control into the margin portion. When a calendar carries out a drops down, it is displayed that it covers and hangs over those control. A display and un-displaying switch by the click of a drops button. A calendar closes and the date is displayed on a text box by the click of the date. (The format of this date can be changed by the argument) In addition, the font size of a text box cannot be changed. ---------------------------------------------------------------------------- << Addition >> [ Palette class ] (1) Cplor Palette control can be made only from preparing Frame control. (2) It can input by [one click] by the emphasis display of a mouse position. ---------------------------------------------------------------------------- << About Re-distribution of ktClsPasteCal.xla / ktClsPasteCal97.xla >> If you include [ktClsPasteCal.xla/ktClsPasteCal97.xla] in your distribution file (workbook which you created using this calendar class add-in), please observe the following license agreement. (1) Common (a) Don't change the contents of [ktClsPasteCal.xla/ktClsPasteCal97.xla]. (b) The following description is carried to "description of ReadMe etc." attached to the software which the user created. " A calendar class add-in [ktClsPasteCal.xla and ktClsPasteCal97.xla] is K.Tsunoda's work. " [AddinBox] http://www.h3.dion.ne.jp/~sakatsu/ http://www.h3.dion.ne.jp/~sakatsu/Bpca_PasteCal.htm (2) In distribution in the limited ranges, such as use in the company, you may distribute freely. (3) In the distribution as the freeware / share software which an individual creates, you may distribute freely. (4) About use by the selling software which a company creates (a) It does not grant a permission that a company uses this calendar class add-in for the selling software for many and unspecified users (share software is included). I think that a company should carry out with the technology of its company. (b) It permits that a company uses this calendar class add-in for the software supplied to a specific user. However, please give the following explanation to a delivery place user, and carry description of (1-b) in a delivery document. " This add-in is distributed as freeware. It is not what was developed at its company. " ---------------------------------------------------------------------------- << History >> 14th Jun. 2005 Ver1.20 The bug of ValueIsNull property was corrected. SpinChange event and CalMonth property was added. 3rd Jun. 2005 Ver1.11 1st English version ----------------------------------------------------------------------------