{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["資格取得届（セル結合）","XML形式定義","LICENSE","README.md"],"not_rendered":{"images":1,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"資格取得届（セル結合）","index":0,"n_rows":97,"n_cols":28,"rows_kept":97,"merged":[[0,14,5,27],[1,1,2,1],[1,2,2,4],[1,5,2,5],[1,6,2,9],[1,10,4,13],[3,1,4,1],[3,2,4,4],[3,5,4,5],[3,6,4,9],[6,1,9,1],[6,2,7,6],[6,7,7,14],[6,15,8,18],[6,19,8,27],[8,2,9,6],[8,7,9,14],[9,15,12,15],[9,16,12,18],[9,19,10,27],[10,1,15,1],[10,2,12,6],[10,7,12,14],[11,19,12,21],[11,22,12,23],[11,24,12,25],[11,26,12,27],[13,2,15,6],[13,7,15,14],[13,15,15,15],[13,16,16,17],[13,18,15,18],[13,19,16,20],[13,21,15,21],[13,22,15,27],[17,1,19,1],[17,2,19,16],[17,17,18,23],[17,24,20,27],[19,17,20,17],[19,18,20,19],[19,20,20,21],[19,22,20,23],[20,1,23,1],[20,2,23,16],[21,17,23,17],[21,18,23,23],[21,24,24,26],[21,27,23,27],[25,1,40,1],[25,2,26,2],[25,3,26,9],[25,10,26,14],[25,15,26,27],[27,2,29,2],[27,3,29,9],[27,10,29,14],[27,15,30,16],[27,17,30,19],[27,20,30,21],[27,22,30,27],[31,2,32,2],[31,3,32,27],[33,2,35,2],[33,3,35,25],[33,26,40,27],[37,2,39,2],[37,3,39,24],[37,25,39,25],[41,1,42,9],[41,10,44,10],[41,11,44,15],[41,21,48,23],[41,24,44,24],[41,25,44,25],[41,26,48,27],[42,16,44,19],[42,20,44,20],[43,1,44,1],[43,2,44,3],[43,4,44,4],[43,5,44,6],[43,7,44,9],[45,1,47,1],[45,2,47,3],[45,4,47,4],[45,5,47,6],[45,7,47,7],[45,8,47,8],[45,9,47,9],[45,10,47,10],[45,11,47,20],[45,24,48,24],[45,25,48,25],[48,2,48,3],[48,5,48,6],[49,1,50,14],[49,15,50,22],[49,23,54,26],[49,27,54,27],[51,1,52,6],[51,7,52,10],[51,11,52,12],[51,13,52,14],[51,15,54,16],[51,17,54,17],[51,18,54,18],[51,19,54,19],[51,20,54,20],[51,21,54,21],[51,22,54,22],[53,1,54,6],[53,7,54,14],[55,1,59,27],[60,1,61,8],[60,10,61,11],[60,12,61,12],[60,13,61,13],[60,14,61,14],[60,15,61,15],[60,16,61,16],[60,17,61,17],[60,18,61,19],[60,20,61,26],[63,1,86,1],[63,2,64,27],[65,3,66,5],[65,6,66,10],[65,11,66,13],[65,14,66,14],[65,15,66,16],[65,17,66,17],[65,18,66,19],[65,20,66,27],[67,3,72,27],[73,3,74,15],[73,16,74,23],[73,24,74,26],[75,4,76,4],[75,5,76,5],[75,6,76,6],[75,7,76,7],[75,8,76,8],[75,9,76,9],[75,10,76,10],[75,11,76,11],[75,12,76,15],[75,16,76,20],[75,21,76,26],[77,3,78,3],[77,4,78,4],[77,5,78,5],[77,6,78,6],[77,7,78,7],[77,8,78,8],[77,9,78,9],[77,10,78,10],[77,11,78,11],[77,12,78,15],[77,16,78,20],[77,21,78,26],[79,3,80,3],[79,4,80,4],[79,5,80,5],[79,6,80,6],[79,7,80,7],[79,8,80,8],[79,9,80,9],[79,10,80,10],[79,11,80,11],[79,12,80,15],[79,16,80,20],[79,21,80,26],[81,3,82,3],[81,4,82,4],[81,5,82,5],[81,6,82,6],[81,7,82,7],[81,8,82,8],[81,9,82,9],[81,10,82,10],[81,11,82,11],[81,12,82,15],[81,16,82,20],[81,21,82,26],[83,3,85,8],[83,9,85,11],[83,12,85,15],[83,16,85,16],[83,17,85,18],[83,19,85,22],[83,23,85,25],[83,26,85,26],[86,3,86,26],[87,1,98,1],[87,2,88,14],[87,16,88,21],[87,22,88,27],[90,2,91,3],[90,4,91,4],[90,5,91,5],[90,6,91,6],[90,7,91,7],[90,8,91,8],[90,9,91,9],[93,3,94,4],[93,5,94,6],[93,7,94,7],[93,8,94,9],[93,10,94,10],[93,11,94,13],[96,3,97,5],[96,6,97,9],[96,10,97,12],[96,13,97,20]]}
[{"$nulls":14},"・支所が管轄する所属所（小中学校等）→4部印刷　(所属所用控1部、\n　支所用1部、支部用2部、全て受付印要)\n・総務事務システム対象所属（県立学校等）→2部印刷　(支部用2部、\n　受付印は総務事務管理課が押印)\n・その他の所属所→3部印刷(所属所用控1部、支部用2部、全て受付印要)"]
[null,"○","組合員",{"$nulls":3},"短期組合員",{"$nulls":3},"資格取得届書"]
[]
[null,null,"船員組合員",{"$nulls":3},"船員短期組合員"]
[]
[null,"（様式規13号）"]
[null,"C/H","所属所名",{"$nulls":4},"氏名（姓と名の間は1文字空ける）",{"$nulls":7},"職名",{"$nulls":3},"教諭"]
[]
[null,null,"所属所コード",{"$nulls":4},"組合員証番号"]
[{"$nulls":15},"異動\n区分","性別",null,null,"生年月日"]
[null,1,"桜通り小学校",{"$nulls":4},"電子　太郎"]
[{"$nulls":19},"元号",null,null,"年",null,"月",null,"日"]
[]
[null,null,12345,{"$nulls":4},12345678,{"$nulls":7},2,"男:1\n女:2",null,1,"昭:3\n平:4",null,3,550401]
[]
[]
[null,1,2,{"$nulls":3},6,7,{"$nulls":6},14,15,null,null,17,null,null,18,19,{"$nulls":4},24]
[null,"カード\nNo","氏名フリガナ（姓と名の間は1文字空ける）",{"$nulls":14},"資格取得年月日",{"$nulls":6},"福祉医療該当区分（市町村から医療費助成を受けているとき記入）"]
[]
[{"$nulls":18},"年",null,"月",null,"日"]
[null,1,"デンシ　タロウ"]
[{"$nulls":17},"令和\n5",30930,{"$nulls":5},"障害者医療:3\n母子医療等:4\n福祉給付金等:8"]
[]
[]
[null,35,36,{"$nulls":13},49,66,67,{"$nulls":4},72,{"$nulls":3},78]
[null,"住\n所","カード\nNo","郵便番号（ハイフン記入しないこと）",{"$nulls":6},"市区町村コード",{"$nulls":4},"住所１（都道府県は愛知県の場合記入不要）"]
[]
[null,null,2,4600003,{"$nulls":6},231061,{"$nulls":4},"都道\n府県",null,"愛知県",null,null,"市区\n町村",null,"名古屋市"]
[]
[]
[null,null,35,41,{"$nulls":5},47,36,{"$nulls":3},40]
[null,null,"カード\nNo","住所２（住所１で記入した市区町村名に続く住所）"]
[]
[null,null,"Ａ","名古屋市中区錦３丁目１番１号",{"$nulls":22},"「Ａ」欄に記入しきれない場合にのみ「Ｂ」欄に続きを記入してください"]
[]
[]
[null,null,35,36]
[null,null,"Ｂ","十六銀行名古屋ビル５階"]
[]
[]
[null,null,35,36]
[null,"支部使用欄のため記入しない",{"$nulls":8},"カード\nNo","基礎年金番号(10桁)\n※ハイフン記入しないこと",{"$nulls":9},"今回資格取得前に加入していた共済組合\n※該当する方に〇を記入",null,null,"有",null,"有の場合、次の段も記入"]
[{"$nulls":16},"未付番の場合○を記入→"]
[null,"カード\nNo","短期:1",null,"カード\nNo","種別",null,"他支部"]
[]
[null,"Ｃ",null,null,4,{"$nulls":5},8,1234567890,{"$nulls":12},"無","○"]
[]
[]
[null,35,36,null,35,58,null,59,null,null,35,36,{"$nulls":8},45]
[null,"今回資格取得前に加入していた共済組合名",{"$nulls":13},"左記組合加入期間の末日",{"$nulls":7},"他支部からの転入のため、他支部交付の組合員証等を返却する場合、返却枚数を記入→"]
[]
[null,"公立学校共済組合の場合→",{"$nulls":5},"公立学校共済組合",{"$nulls":5},"支部",{"$nulls":4},"年",null,"月",null,"日"]
[]
[null,"他の共済組合の場合→"]
[]
[null,"上記のとおり組合員（又は船員組合員、短期組合員、船員短期組合員）の資格を取得しましたので届け出ます。\n併せて一般財団法人愛知県教育職員互助会（以下「互助会」という。）の会員の資格を取得したときは、互助会の給付金及び事業を受けるために必要な情報を互助会に提供することを承諾します。\nまた、個人番号については、地方公務員共済組合法施行規程93条の規定に基づき地方公共団体情報システム機構から提供を受けます。"]
[]
[]
[]
[]
[null,"公立学校共済組合愛知支部長殿",{"$nulls":8},"令和",null,4,"年",8,"月",25,"日","氏名",null,"電子　太郎"]
[]
[]
[null,"勤務先所属所記載欄","上記資格を取得した者に係る任用等について、勤務先所属所が記入してください。"]
[]
[{"$nulls":3},"任命権者",{"$nulls":7},"任期の定め",{"$nulls":3},"あり",null,null,"なし",null,"任期の定めがある場合、以下も記入"]
[]
[{"$nulls":3},"○　複数任用の合算による資格取得の場合、合算する任用をすべて記入（勤務日数、勤務時間数、報酬月額は合算値により記入）\n○「職員の区分」は、再任用(フルタイム)、再任用(短時間)、任期付任用(フルタイム)、任期付任用(短時間)、臨時的任用、会計年度(短時間)、会計年度(フルタイム12月経過後)、会計年度(フルタイム12月経過前)のいずれかを記入\n○「※」の条件に該当しない場合は通常、組合員の資格を取得しない（月勤務日数又は週勤務時間数が正規職員の4分の3未満である場合は、「週勤務時間数20時間以上」「報酬月額88,000円以上」の両方を満たす場合のみ組合員となる）"]
[]
[]
[]
[]
[]
[{"$nulls":3},"任用期間 ※2月超、又は2月以内だが更新の見込あり",{"$nulls":12},"記入後内容を確認し、担当者✔→"]
[]
[{"$nulls":4},"年","月","日",null,null,"年","月","日","更新の見込有無（2月超の場合は記入不要）",{"$nulls":3},"勤務先所属所名",{"$nulls":4},"職員の区分"]
[]
[{"$nulls":3},"令和",{"$nulls":3},"～","令和"]
[]
[{"$nulls":3},"令和",{"$nulls":3},"～","令和"]
[]
[{"$nulls":3},"令和",{"$nulls":3},"～","令和"]
[]
[{"$nulls":3},"月勤務日数（正規職員の4分の3以上/未満を記入）",{"$nulls":8},"週勤務時間数\n※週20時間以上",{"$nulls":4},"時間",null,"報酬月額\n※88,000円以上",{"$nulls":6},"円"]
[]
[]
[]
[null,"所属所長証明欄","上記の記載事項は事実と相違ないものと認めます。",{"$nulls":13},"所属所の文書受付印",{"$nulls":5},"愛知支部（支所）受付印"]
[]
[null,null,"※総務事務システム対象所属所にあっては、総務事務管理課長が証明・文書受付印を押印"]
[null,null,"令和",null,null,"年",null,"月",null,"日",{"$nulls":13},{"$f":"QR(XML形式定義!D28)","v":""}]
[]
[]
[{"$nulls":3},"TEL",{"$nulls":3},"-",null,null,"-"]
[]
[]
[{"$nulls":3},"所属所名",{"$nulls":6},"職氏名"]

{"sheet":"XML形式定義","index":1,"n_rows":28,"n_cols":5,"rows_kept":28}
["セル","参照文字列","タグ","生成文字列","参照シート"]
["B2",{"$f":"$E$2&A2","v":"'資格取得届（セル結合）'!B2"},"col01",{"$f":"\"<\"&C2&\">\"&INDIRECT(B2)&\"</\"&C2&\">\"","v":"<col01>○</col01>"},"'資格取得届（セル結合）'!"]
["B4",{"$f":"$E$2&A3","v":"'資格取得届（セル結合）'!B4"},"col02",{"$f":"\"<\"&C3&\">\"&INDIRECT(B3)&\"</\"&C3&\">\"","v":"<col02></col02>"}]
["F2","'資格取得届（セル結合）'!F2","col03",{"$f":"\"<\"&C4&\">\"&INDIRECT(B4)&\"</\"&C4&\">\"","v":"<col03></col03>"}]
["F4","'資格取得届（セル結合）'!F4","col04",{"$f":"\"<\"&C5&\">\"&INDIRECT(B5)&\"</\"&C5&\">\"","v":"<col04></col04>"}]
["T7","'資格取得届（セル結合）'!T7","col05",{"$f":"\"<\"&C6&\">\"&INDIRECT(B6)&\"</\"&C6&\">\"","v":"<col05>教諭</col05>"}]
["C11","'資格取得届（セル結合）'!C11","col06",{"$f":"\"<\"&C7&\">\"&INDIRECT(B7)&\"</\"&C7&\">\"","v":"<col06>桜通り小学校</col06>"}]
["C14","'資格取得届（セル結合）'!C14","col07",{"$f":"\"<\"&C8&\">\"&INDIRECT(B8)&\"</\"&C8&\">\"","v":"<col07>12345</col07>"}]
["H11","'資格取得届（セル結合）'!H11","col08",{"$f":"\"<\"&C9&\">\"&INDIRECT(B9)&\"</\"&C9&\">\"","v":"<col08>電子　太郎</col08>"}]
["H14","'資格取得届（セル結合）'!H14","col09",{"$f":"\"<\"&C10&\">\"&INDIRECT(B10)&\"</\"&C10&\">\"","v":"<col09>12345678</col09>"}]
["S14","'資格取得届（セル結合）'!S14","col10",{"$f":"\"<\"&C11&\">\"&INDIRECT(B11)&\"</\"&C11&\">\"","v":"<col10>1</col10>"}]
["V14","'資格取得届（セル結合）'!V14","col11",{"$f":"\"<\"&C12&\">\"&INDIRECT(B12)&\"</\"&C12&\">\"","v":"<col11>3</col11>"}]
["W14","'資格取得届（セル結合）'!W14","col12",{"$f":"\"<\"&C13&\">\"&INDIRECT(B13)&\"</\"&C13&\">\"","v":"<col12>550401</col12>"}]
["C21","'資格取得届（セル結合）'!C21","col13",{"$f":"\"<\"&C14&\">\"&INDIRECT(B14)&\"</\"&C14&\">\"","v":"<col13>デンシ　タロウ</col13>"}]
["S22","'資格取得届（セル結合）'!S22","col14",{"$f":"\"<\"&C15&\">\"&INDIRECT(B15)&\"</\"&C15&\">\"","v":"<col14>30930</col14>"}]
["AB22","'資格取得届（セル結合）'!AB22","col15",{"$f":"\"<\"&C16&\">\"&INDIRECT(B16)&\"</\"&C16&\">\"","v":"<col15></col15>"}]
["D28","'資格取得届（セル結合）'!D28","col16",{"$f":"\"<\"&C17&\">\"&INDIRECT(B17)&\"</\"&C17&\">\"","v":"<col16>4600003</col16>"}]
["K28","'資格取得届（セル結合）'!K28","col17",{"$f":"\"<\"&C18&\">\"&INDIRECT(B18)&\"</\"&C18&\">\"","v":"<col17>231061</col17>"}]
["R28","'資格取得届（セル結合）'!R28","col18",{"$f":"\"<\"&C19&\">\"&INDIRECT(B19)&\"</\"&C19&\">\"","v":"<col18>愛知県</col18>"}]
["W28","'資格取得届（セル結合）'!W28","col19",{"$f":"\"<\"&C20&\">\"&INDIRECT(B20)&\"</\"&C20&\">\"","v":"<col19>名古屋市</col19>"}]
["D34","'資格取得届（セル結合）'!D34","col20",{"$f":"\"<\"&C21&\">\"&INDIRECT(B21)&\"</\"&C21&\">\"","v":"<col20>名古屋市中区錦３丁目１番１号</col20>"}]
["D38","'資格取得届（セル結合）'!D38","col21",{"$f":"\"<\"&C22&\">\"&INDIRECT(B22)&\"</\"&C22&\">\"","v":"<col21>十六銀行名古屋ビル５階</col21>"}]
["U43","'資格取得届（セル結合）'!U43","col22",{"$f":"\"<\"&C23&\">\"&INDIRECT(B23)&\"</\"&C23&\">\"","v":"<col22></col22>"}]
["L46","'資格取得届（セル結合）'!L46","col23",{"$f":"\"<\"&C24&\">\"&INDIRECT(B24)&\"</\"&C24&\">\"","v":"<col23>1234567890</col23>"}]
["Z42","'資格取得届（セル結合）'!Z42","col24",{"$f":"\"<\"&C25&\">\"&INDIRECT(B25)&\"</\"&C25&\">\"","v":"<col24></col24>"}]
["Z46","'資格取得届（セル結合）'!Z46","col25",{"$f":"\"<\"&C26&\">\"&INDIRECT(B26)&\"</\"&C26&\">\"","v":"<col25>○</col25>"}]
[]
[{"$nulls":3},{"$f":"D2&D3&D4&D5&D6&D7&D8&D9&D10&D11&D12&D13&D14&D15&D16&D17&D18&D19&D20&D21&D22&D23&D24&D25&D26&D27","v":"<col01>○</col01><col02></col02><col03></col03><col04></col04><col05>教諭</col05><col06>桜通り小学校</col06><col07>12345</col07><col08>電子　太郎</col08><col09>12345678</col09><col10>1</col10><col11>3</col11><col12>550401</col12><col13>デンシ　タロウ</col13><col14>30930</col14><col15></col15><col16>4600003</col16><col17>231061</col17><col18>愛知県</col18><col19>名古屋市</col19><col20>名古屋市中区錦３丁目１番１号</col20><col21>十六銀行名古屋ビル５階</col21><col22></col22><col23>1234567890</col23><col24></col24><col25>○</col25>"}]

{"sheet":"LICENSE","index":2,"n_rows":21,"n_cols":1,"rows_kept":21}
["MIT License"]
[]
["Copyright (c) 2017 Yasunori Ikeda"]
[]
["Permission is hereby granted, free of charge, to any person obtaining a copy"]
["of this software and associated documentation files (the \"Software\"), to deal"]
["in the Software without restriction, including without limitation the rights"]
["to use, copy, modify, merge, publish, distribute, sublicense, and/or sell"]
["copies of the Software, and to permit persons to whom the Software is"]
["furnished to do so, subject to the following conditions:"]
[]
["The above copyright notice and this permission notice shall be included in all"]
["copies or substantial portions of the Software."]
[]
["THE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR"]
["IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,"]
["FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE"]
["AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER"]
["LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,"]
["OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE"]
["SOFTWARE."]

{"sheet":"README.md","index":3,"n_rows":172,"n_cols":1,"rows_kept":172}
["# QRCodeLibVBA"]
["QRCodeLibVBAは、Excel VBAで書かれたQRコード生成ライブラリです。  "]
["JIS X 0510:2004に基づくモデル2コードシンボルを生成します。"]
[]
["## 特徴"]
[{"$f":"- 数字・英数字・8ビットバイト・漢字モードに対応しています","v":{"$error":"#NAME?"}}]
[{"$f":"- 分割QRコードを作成可能です","v":{"$error":"#NAME?"}}]
[{"$f":"- BMP,EMF,GIF,PNG,SVG,TIFFファイルに保存可能です","v":{"$error":"#NAME?"}}]
[{"$f":"- QRコードをIPictureDispオブジェクトとして取得可能です","v":{"$error":"#NAME?"}}]
[{"$f":"- 配色を指定可能です","v":{"$error":"#NAME?"}}]
[{"$f":"- 文字セットを指定可能です","v":{"$error":"#NAME?"}}]
[{"$f":"- QRコードをクリップボードに保存可能です","v":{"$error":"#NAME?"}}]
[]
[]
["## クイックスタート"]
["QRCodeLib.xlamを参照設定してください。  "]
[]
[]
["## 使用方法"]
["### 例１．最小限のコードを示します"]
[]
["```VBA"]
["Dim sbls As Symbols"]
["Set sbls = CreateSymbols()"]
["sbls.AppendText \"012345abcdefg\""]
[]
["Dim pict As stdole.IPictureDisp"]
["Set pict = sbls(0).GetPicture()"]
["```"]
[]
["### 例２．誤り訂正レベルを指定する"]
["CreateSymbols関数の引数に、ErrorCorrectionLevel列挙型の値を設定してSymbolsオブジェクトを生成します。"]
[]
["```VBA"]
["Dim sbls As Symbols"]
["Set sbls = CreateSymbols(ErrorCorrectionLevel.L) ' 7%"]
["Set sbls = CreateSymbols(ErrorCorrectionLevel.M) ' 15%(default)"]
["Set sbls = CreateSymbols(ErrorCorrectionLevel.Q) ' 25%"]
["Set sbls = CreateSymbols(ErrorCorrectionLevel.H) ' 30%"]
["```"]
[]
["### 例３．型番の上限を指定する"]
["CreateSymbols関数のmaxVer引数を設定してSymbolsオブジェクトを生成します。"]
[]
["```VBA"]
["Dim sbls As Symbols"]
["Set sbls = CreateSymbols(maxVer:=10)"]
["```"]
[]
["### 例４．文字セットを指定する"]
["CreateSymbols関数のcharsetName引数を設定してSymbolsオブジェクトを生成します。"]
["（ADODB.Stream に依存しています。使用可能な文字セットはレジストリ[HKEY_CLASSES_ROOT\\MIME\\Database\\Charset]を確認してください。）"]
[]
["既定値はShift_JISです。UTF-8の設定例を以下に示します。"]
[]
[]
["```VBA"]
["Dim sbls As Symbols"]
["Set sbls = CreateSymbols(charsetName:=\"UTF-8\")"]
["```"]
[]
["### 例５．分割QRコードを作成する"]
["CreateSymbols関数の引数を設定してSymbolsオブジェクトを生成します。型番の上限を指定しない場合は、型番40を上限に分割されます。  "]
[]
["型番1を上限に分割し、各QRコードのIPictureDispオブジェクトを取得する例を示します。"]
[]
["```VBA"]
["Dim sbls As Symbols"]
["Set sbls = CreateSymbols(maxVer:=1, allowStructuredAppend:=True)"]
["sbls.AppendText \"abcdefghijklmnopqrstuvwxyz\""]
["    "]
["Dim pict As stdole.IPictureDisp"]
["Dim sbl As Symbol"]
["    "]
["For Each sbl In sbls"]
["    Set pict = sbl.GetPicture()"]
["Next"]
["```"]
[]
["### 例６．画像形式を指定してIPictureDispオブジェクトを取得する"]
["GetPictureメソッドのpicType引数を設定します。"]
[]
["```VBA"]
["Dim sbls As Symbols"]
["Set sbls = CreateSymbols()"]
["sbls.AppendText \"012345abcdefg\""]
[]
["Dim pict As stdole.IPictureDisp"]
[]
["' Bitmap"]
["Set pict = sbls(0).GetPicture(picType:=Bitmap)"]
[]
["' Metafile"]
["Set pict = sbls(0).GetPicture(picType:=EnhMetaFile)"]
["```"]
[]
["### 例７．ファイルへ保存する"]
["SymbolクラスのSaveAsメソッドを使用します。"]
[]
["```VBA"]
["Dim sbls As Symbols"]
["Set sbls = CreateSymbols()"]
["sbls.AppendText \"012345abcdefg\""]
["    "]
["' monochrome BMP"]
["sbls(0).SaveAs \"filename\""]
[]
["' true color BMP"]
["sbls(0).SaveAs \"filename\", fmt:=fmtTrueColor"]
[]
["' EMF"]
["sbls(0).SaveAs \"filename\", fmt:=fmtEMF"]
[]
["' GIF"]
["sbls(0).SaveAs \"filename\", fmt:=fmtGIF"]
[]
["' transparent GIF"]
["sbls(0).SaveAs \"filename\", fmt:=fmtGIF, bkStyle:=bkTransparent"]
[]
["' monochrome PNG"]
["sbls(0).SaveAs \"filename\", fmt:=fmtPNG"]
[]
["' true color PNG "]
["sbls(0).SaveAs \"filename\", fmt:=fmtPNG + fmtTrueColor"]
[]
["' transparent PNG "]
["sbls(0).SaveAs \"filename\", fmt:=fmtPNG + fmtTrueColor, bkStyle:=bkTransparent"]
[]
["' SVG"]
["sbls(0).SaveAs \"filename\", fmt:=fmtSVG"]
[]
["' monochrome TIFF"]
["sbls(0).SaveAs \"filename\", fmt:=fmtTIFF"]
[]
["' true color TIFF"]
["sbls(0).SaveAs \"filename\", fmt:=fmtTIFF + fmtTrueColor"]
[]
["' bilevel TIFF"]
["sbls(0).SaveAs \"filename\", fmt:=fmtTIFF + fmtBilevel"]
[]
["' 10 pixels per module"]
["sbls(0).SaveAs \"filename\", moduleSize:=10"]
["    "]
["' specify foreground and background colors"]
["sbls(0).SaveAs \"filename\", foreRgb:=\"#0000FF\", backRgb:=\"#FFFF00\""]
["```"]
[]
["### 例８．クリップボードへ保存する"]
["SymbolクラスのSetToClipBoardメソッドを使用します。"]
[]
["```VBA"]
["Dim sbls As Symbols"]
["Set sbls = CreateSymbols()"]
["sbls.AppendText \"012345abcdefg\""]
[]
["' Bitmap "]
["sbls(0).SetToClipBoard"]
[]
["' Metafile"]
["sbls(0).SetToClipboard fmt:=fmtEMF"]
["```"]
[]
["### 例９．型番を固定して画像サイズを一定にする"]
["CreateSymbols関数のmaxVer引数とfixedSize引数を設定してSymbolsオブジェクトを生成します。  "]
["常にmaxVer引数で指定された型番で生成されます。  "]
["型番10に固定する例を以下に示します。"]
[]
["```VBA"]
["Dim sbls As Symbols"]
["Set sbls = CreateSymbols(maxVer:=10, fixedSize:=True)"]
["sbls.AppendText \"Hello World\""]
["```"]