Edwin's Power Tools version 1.1.2 January 27, 1997, by Edwin H.B. TAM (Excel Add-In for Excel 5 and 7, Mac & PC) Copyright © 1997 ALL RIGHTS RESERVED About the author - I am currently an Accounting and Finance undergraduate final year oversea student (from Hong Kong) at Lancaster University (UK). E-mail the author at : edwintam@vol.net This is also the address for tech support, comments, and bug reports. Edwin Tam's Home Page : http://www.vol.net/~edwintam/ ©Edwin's Power Tools is an Excel Add-In that adds useful functions to Microsoft Excel. It is a cross-platform add-in, which means it is fully compatible with both the Apple Macintosh and Windows PC. Besides, it is compatible with Excel 5 and Excel 7. Please do NOT distribute modified versions of Edwin's Power Tools. Also, please distribute the shareware as a complete package, including all the files in its original archive(s). Shareware info Edwin's Power Tools is a shareware; it is NOT free. If you use Edwin's Power Tools for more 15 days, you MUST pay a $30 registration fee. To register, please fill-in the registration form provided in Edwin's Power Tools and send the finished form to me together with the registration fee. I accept most currencies as well as cheques issued by banks in Hong Kong, US, and UK. Or, if you didn't have access to the Add-In, just send me your name, e-mail address, postal address, the registration fee, together with the following statement with your signature : " I agree not to modify, adapt, translate, reverse engineer, decompile, disassemble or otherwise attempt to discover the source code of Edwin's Power Tools Excel Add-In." The latest registration addresses (valid until May 31,1997) are : USA : King-Yee Ng P.O. Box 1444 W.A.S. Ames, IA 50014-1444 United States Rest of the world : Edwin H.B. TAM Furness College Lancaster University Lancaster LA1 4YG United Kingdom If you are registering by bank cheques, I suggest you e-mail me first for further instructions. Or you can refer to the EPT Home Page for the latest registration instructions. Special Offer for Mac Users! As a gift to all Macintosh fans (I myself is one!), any Mac user who can send me a screen capture printout of your beautiful Macintosh desktop and tell me 10 reasons "Why you have chosen the Apple Macintosh as your platform", I can give a US$10 discount (i.e. a reduced price of US$20 per license). This offer is limited to 1 license per person. (The online registration form will deal with this discount automatically.) List of features For a full list of features, please refer to the EPT Functions page at : http://www.vol.net/~edwintam/functions.html System Requirements Edwin's Power Tools can be used with the following Microsoft Excel versions: 7.0 - Microsoft Windows 95 5.0 - 32-bit Windows (Microsoft Windows NT 3.x) 5.0 - 16-bit Windows (Microsoft Windows 3.x) 5.0 - Macintosh and Power Macintosh Installation Edwin's Power Tools should reside in the Microsoft Excel Library directory. The path to this directory is different depending on which version of Excel you are running. For Windows users : For standalone Excel 5.0, you will find the LIBRARY directory directly under the EXCEL directory (for example, C:\EXCEL\LIBRARY). For MS Office and Excel 7.0, you will find the LIBRARY directory under the MSOFFICE and EXCEL directories (for example, C:\MSOFFICE\EXCEL\LIBRARY). For Macintosh users : For standalone Excel 5.0, you will find the Macro Library folder directly inside the Microsoft Excel 5 folder (for example, Hard Disk:Microsoft Excel 5:Macro Library). For MS Office 4.2 or 4.2.1, you will find the Macro Library folder inside the Microsoft Excel 5 folder (for example, Hard Disk:Microsoft Office 4.2.1:Microsoft Excel 5:Macro Library). To Install Edwin's Power Tools -- 1. Copy EPT.XLA, EPTPART.XLA and REG_CODE.TXT to the Microsoft Excel Library Directory. 2. Run Microsoft Excel. 3. On the Tools menu, select Add-Ins. 4. Check the "Edwin's Power Tools" checkbox. (If you couldn't find the checkbox, locate EPT.XLA by pressing the "Browse" button.) 5. Click OK. Version History Version 1.1.2 -- (27 Jan 97) Fixes a problem which causes some of the Excel 5 for Windows to quit unexpectedly while EPT is trying to modify the shortcut menus. This problem also causes a "Not enough memory to start Excel" error while trying to launch Excel again. Excel cannot be restarted without restarting Windows. This problem is not caused by errors in the VBA codes but by the inconsistency of Excel 5 across the PC and Mac platforms. Slight modifications to EPT Power Append. Version 1.1.1 -- (6 Jan 97) Minor bug fixes and updated readme file. Version 1.1 -- (1 Jan 97) The 30 days time limit for the use of EPT has been completely removed. This version won't expire. (Version 1.0 would kill itself after 30 days of use.) Bug fix to "Duplicate Sheets". Version 1.0 -- (26 Dec 96) First releaase of EPT. Disclaimer The author, Edwin H.B. TAM, makes no warranties, either express or implied, regarding the fitness of "Edwin's Power Tools" for any particular purpose. Use "Edwin's Power Tools" at your own risk. The authors claim no liability for data loss or any other problems caused directly or indirectly by "Edwin's Power Tools".