------------------------------------------------------------ Html Maker -Ver. 2.20Jp- ------------------------------------------------------------ Html Makerは元々は海外のQ.AサイトMr.Excel.comの掲示板にワークシート イメージを再現する為に作りました。 httd://www.mrexcel.com/board/index.php その他にも色々と使い道があると思いますので公開します。 作成されるイメージのメニュー部分は日本語版に変更してあります。 英語版メニューを使用したい場合は、標準モジュールのMod_Html内の文字列 を変えると変更できます。 もしくは私のWebSiteに英語版がありますのでダウンロードして下さい。 http://www.interq.or.jp/sun/puremis/colo/ もくじ -------- 1.このアドインについて 2.開発環境 3.インストールの方法 4.動作環境 5.転載 6.再配布 7.免責 8.改定履歴 9.作者 10.既知の問題 11.権利と棄権について ------------------- 1.このアドインについて ------------------- Htmlが許可されているネットの掲示板に投稿する際にこのアドインは質問や回答 を手助けします。"百聞は一見にしかず"の発想でつくりました。 エクセルアプリのイメージをHtmlに変換します。そしてイメージとコードはイン ターネットエクスプローラー(以下IE)に自動的に表示されます。 IEに表示されているボタンをクリックすることで、コードはクリップボードにコ ピーされるので、あとは掲示板に張り付けるだけです。 Htmlに変換されるもの 罫線は海外では利用頻度が低いので変換されません。 ワークブック名 シート名 使用しているエクセルのバージョン OSのバージョン ※これらの有用な情報を掲示板の回答者にメンバーにしらせることで的確な回答を 得る事が出来ます。 -背景色と文字色 ーセル内での文字位置 ーセルに入力されている数式 *IEのJavaScriptをOnにしておく必要があります。 変換された数式は出来上がったイメージの名前ボックスのプルダウンからセルアドレ スを選ぶか、もしくは各セルのハイパーリンクをクリックすることで、数式バーに表 示されます。 また数式コピーボタンを押す事でクリップボードにコピーされます。 アドインのメニューの internet explorer Ctrl panel - でIEのオプションを呼び出す 事ができます。 ------------------- 2.開発環境 ------------------- Windows2000 - Excel 97-SR2 Windows95 - Excel 97-SR2 Windows2000 - Excel2000 Windows98 - Excel2000 You will need to have installed IE 4.01 or later, Does NOT support Netscape Navigator (As of 22/05/2002 - Testing done on other Platforms by Juan Pablo G - Not complete) ------------------- 3.インストールの方法 ------------------- このアドインファイルをアドインフォルダに保存してください。 たぶん下記の場所にあると思いますが、 どこにあるかわからない時はWindowsの検索機能で*.xlaファイルをさがせば見つかると思 います。 保存後、エクセルのメニューのツールーアドインの順にたどってこのアドインにチェック をつけてください。 ------------------- 4.動作環境 ------------------- 開発環境と同じです。Windows XP(英語版)でも動いたという報告は頂きました。 ------------------- 5.掲載 ------------------- お知らせ下さい。 ------------------- 6.再配布 ------------------- お知らせ下さい。 ※共同開発者のIvan氏は英語もしくはスペイン語しかわかりませんので、日本語での連絡は コロスケ(Colo)までおねがいします。英語の場合はどちらかに連絡をお願いします。 ------------------- 7.免責 ------------------- このアドインを使用しておこったいかなる問題に対しても開発者は責任を負いません。 ------------------- 8.改定履歴 ------------------- 11 May 2002 1.22 Released 12 May 2002 1.23 made into Addin 17 May 2002 1.24 Released Mods 18 May 2002 1.25 Released Mods 19 May 2002 1.26 Released Mods 20 May 2002 1.27 Released Mods 23 May 2002 1.28 Released Mods 24 May 2002 2.00 Released Mods and Help 29 May 2002 2.01 OS Mods + update Help/Readme - OS Version tests carried out by Nate O, Mark O'Brien, Juan Pablo and DK (Dan) 5 June 2002 2.11 Released Mod_EmailSheet 5 June 2002 2.12 Released Mods_HTML This was documented On 2002-06-04 21:42 , by "PaddyD" 6 June 2002 2.13 Released Mods 8 June 2002 2.14 Released Mod_EmailSheet 19 June 2002 2.20 Released Supported Borders,Fonts,Pivot Tables,Hyperlinks -------------------------------------- 9.開発者 コロスケ(Colo & Ivan F Moala) ------------------- ------------------- (Dan氏 - Mrexcel MVP) シート送信のコードの利用を下さり有難うございます。 E-Mail: corosuke@chan.co.jp E-Mail: ivanmoala@xtra.co.nz ------------------- 10.既知の問題 ------------------- 現在のバージョンでは特にありませんが、今後の機能改善に係わる理由が有り、行列の非表 示には対応していませんのであしからず。 また、インストール時にプロジェクトまたはライブラリが見つかりませんという、参照設定 エラーが出た場合は手動で参照設定を外して下さい。 ------------------- 11.権利と免責事項 ------------------- 原文(英文)参照願います。 Original English read.me ------------------------------------------------------------ Html Maker -Ver. 2.10- ------------------------------------------------------------ Thank you very much for getting the htmlmaker Add-in for Excel. Html Maker -Ver. 2.10- was developed as an Excel Addin for displaying an Excel worksheet for the message Board @ Mr.Excel.com -------------------------------------- http://www.mrexcel.com/board/index.php -------------------------------------- CONTENTS -------- 1. About this Addin 2. Development environment 3. How to Install this Add-in 4. Environment of operation 5. Re-distribution 6. Reproduction 7. Exemption from responsibility 8. History 9. Developers 10. Known problems 11. LICENCE and DISCLAIMER ------------------- 1. About this Addin ------------------- The intent of this Addin is to make Q & A easier for the boards users. " A PICTURE IS WORTH A 1000 WORDS! " The image of an Excel worksheet is changed into a table which uses HTML tags. The generated image of the table and the code are displayed in Internet Explorer automatically. This can be copied into the Clipboard and then pasted into the BB reply form. What is transfered over to HMTL? - The Workbook name, Excel Version, Operating system & Sheet Name. This is useful in determining syntax and OS differences for getting a applicable response from other board users. - Users can now select from the Dropdown menu (NameBox) to get the formula of a particular cell to show in the FormulaBar. Just like in Excel. - The displayed formula can be copied to the clipboard via a [Copy Formula] button located on the right side of the Top Menu. The formula is copied to the clipboard. - Cell background & Font colour formats - Cell alignments (horizontal / vertical) - Cell merging - Cell formulas - are also available by clicking on the cell hyperlink. (*You need to enable Java script in Internet Exporer.) * you can do this via the Addins commandbuton; >[Internet Explorer Control Panel] [Advanced Tab] --------------------------- 2. Development environment: --------------------------- Windows2000 - Excel 97-SR2 Windows95 - Excel 97-SR2 Windows2000 - Excel2000 Windows98 - Excel2000 You will need to have installed IE 4.01 or later, Does NOT support Netscape Navigator (As of 22/05/2002 - Testing done on other Platforms by Juan Pablo G - Not complete) ----------------------------- 3. How to Install this Add-in ----------------------------- Save the Addin to your Addin Directory. Typical Dir locations are: C:\Program Files\Microsoft Office\Office\Library C:\WINDOWS\Application Data\Microsoft\AddIns If you do not know where your Addin Dir is then; Do a search for *.xla you should be able to get your Addins path from the results. Now in Excel on the Main Toolbar select Tools > Addins....This Addin should be Listed there. If it is not then your will need to either manually browse & load in OR Close & Reopen Excel. --------------------------- 4. Environment of operation --------------------------- The check of operation has been carried out in the above-mentioned development environment. ------------------ 5. Re-distribution ------------------ Download site to be supplied by Colo --------------- 6. Reproduction --------------- If you want please let us know. -------------------------------- 7. Exemption from responsibility -------------------------------- About any damage generated by having used this Add-in, the authors shall not take any responsibility. ------------------------------------- 8. History: ------------------------------------- 11 May 2002 1.22 Released 12 May 2002 1.23 made into Addin 17 May 2002 1.24 Released Mods 18 May 2002 1.25 Released Mods 19 May 2002 1.26 Released Mods 20 May 2002 1.27 Released Mods 23 May 2002 1.28 Released Mods 24 May 2002 2.00 BEAT Released Mods and Help 27 May 2002 2.00 Released Mods and Help 29 May 2002 2.10 Released Mods and Help ------------------------------------ 9. Developers: Colo and Ivan F Moala ------------------------------------ If any errors occur or you have any suggestions then please contact us; Thanks to DK (Dan - Mrexcel MVP) for allowing us to use the emailsheet code E-Mail: corosuke@chan.co.jp E-Mail: ivanmoala@xtra.co.nz ------------------ 10. Known problems: ------------------ i) Java Script is used to show formulas, a message box is not started when the characters ['] or ["] are inputted into one cell. This was documented On 2002-05-17 12:42, by "Jack in the UK" ii) above problem(i) was solved at Ver2.00. -------------------------- 11. LICENCE and DISCLAIMER -------------------------- This program is distributed as FREEWARE. This means that you acquire no rights in it other than the right to use it without having to pay a fee. Use this program entirely at your own risk. This Addin and the accompanying Text file are presented "AS IS" and without warranties as to performance or merchantability or any other warranties weather expressed or implied. All we ask is that you give acknowlegement to the Developers and leave this README file and the GENERATED acknowledgement Code @ the End of the HTML Table - This acknowledges the Authors and where to get the code from. IN SHORT ENJOY !! ---------------------------------------------------------------- YOU MUST AGREE TO THIS BEFORE USING THE PROGRAM ---------------------------------------------------------------- ---------------------------------------------------------------- LIMITED WARRANTY AND DISCLAIMER OF WARRANTY - Long Version ---------------------------------------------------------------- THIS ADDIN AND ACCOMPANYING WRITTEN MATERIAL (INCLUDING INSTRUCTIONS FOR USE) ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. FURTHER, THE DEVELOPERS DO NOT WARRANT, GUARANTEE, OR MAKE ANY REPRESENTATIONS REGARDING THE USE, OR THE RESULTS OF USE, OF THE ADDIN OR WRITTEN MATERIALS IN TERMS OF CORRECTNESS, ACCURACY, RELIABILITY, CURRENTNESS, OR OTHERWISE. THE ENTIRE RISK AS TO THE RESULTS AND PERFORMANCE OF THE ADDIN IS ASSUMED BY YOU. IF THE ADDIN OR WRITTEN MATERIALS ARE DEFECTIVE, YOU, AND NOT DEVELOPERS OR ANY OTHER PARTY THAT HAS DISTRIBUTORED THE ADDIN , WILL ASSUME THE ENTIRE COST OF ALL NECESSARY SERVICING, REPAIR, OR CORRECTION. THE ABOVE IS THE ONLY WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES. NO ORAL OR WRITTEN INFORMATION OR ADVICE GIVEN BY THE DEVELOPERS OR ANY ONE ELSE WHO HAS DISTRIBUTED THE ADDIN SHALL CREATE A WARRANTY OR IN ANY WAY INCREASE THE SCOPE OF THIS WARRANTY AND YOU MAY NOT RELY ON ANY SUCH INFORMATION OR ADVICE. YOU MAY HAVE OTHER RIGHTS WHICH VARY FROM STATE TO STATE AND COUNTRY TO COUNTRY. NEITHER DEVELOPERS NOR ANYONE ELSE WHO HAS BEEN INVOLVED IN THE CREATION, PRODUCTION OR DELIVERY OF THIS ADDIN SHALL BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL OR INCIDENTAL DAMAGES (INCLUDING DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION, AND THE LIKE) ARISING OUT OF THE USE OR INABILITY TO USE SUCH PRODUCT EVEN IF GENESOFT DEVELOPMENTS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. ACKNOWLEDGMENT BY USING THIS VERSION OF HTMLMAKER YOU ACKNOWLEDGE THAT YOU HAVE READ THIS LIMITED WARRANTY, UNDERSTAND IT, AND AGREE TO BE BOUND BY ITS' TERMS AND CONDITIONS. YOU ALSO AGREE THAT THE LIMITED WARRANTY IS THE COMPLETE AND EXCLUSIVE STATEMENT OF AGREEMENT BETWEEN THE PARTIES AND SUPERSEDE ALL PROPOSALS OR PRIOR AGREEMENTS, ORAL OR WRITTEN, AND ANY OTHER COMMUNICATIONS BETWEEN THE PARTIES RELATING TO THE SUBJECT MATTER OF THE LIMITED WARRANTY.