{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["main","ＧＮＴ","param"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"main","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,1,6,2]]}
["添付資料"]
[]
["日付","2022-05-20"]
[]
[]
[]
["保存ファイル名","業務日報2022_05_20"]
[null,"（基礎ファイル名+日付）"]
[]
[null,"以下の部分は自由にカスタマイズ出来ます"]
["作成者"]
["業務詳細"]
[]
[]
[]
[]
[]
["面談者"]
[]
["特記事項"]

{"sheet":"ＧＮＴ","index":1,"n_rows":46,"n_cols":36,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["プロジェクト系のタスク",null,2022,"年",3,"月",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI2","v":"2022-04-01"},"月"]
["青枠で年、月を選択してカレンダー更新ボタンを押す",null,"2022-03-01","2022-03-01","2022-03-02","2022-03-03","2022-03-04","2022-03-05","2022-03-06","2022-03-07","2022-03-08","2022-03-09","2022-03-10","2022-03-11","2022-03-12","2022-03-13","2022-03-14","2022-03-15","2022-03-16","2022-03-17","2022-03-18","2022-03-19","2022-03-20","2022-03-21","2022-03-22","2022-03-23","2022-03-24","2022-03-25","2022-03-26","2022-03-27","2022-03-28","2022-03-29","2022-03-30","2022-03-31","2022-04-01","2022-04-02"]
[null,"(オートカレンダー,土,日グレー処理）",{"$f":"DAY(EOMONTH(C2,0))","v":31},44621,44622,44623,44624,44625,44626,44627,44628,44629,44630,44631,44632,44633,44634,44635,44636,44637,44638,44639,44640,44641,44642,44643,44644,44645,44646,44647,44648,44649,44650,44651,44652,44653]
[null,"予定　■"]
[null,"実際　■"]
[null,"★更新ボタンを押すとタスク表もクリアされます★"]
[null,"サンプルタスク1"]
[]
[]
[null,"サンプルタスク２"]
[]
[]
[null,"サンプルタスク3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2022-03-01","2022-03-02","2022-03-03","2022-03-04","2022-03-05","2022-03-06","2022-03-07","2022-03-08","2022-03-09","2022-03-10","2022-03-11","2022-03-12","2022-03-13","2022-03-14","2022-03-15","2022-03-16","2022-03-17","2022-03-18","2022-03-19","2022-03-20","2022-03-21","2022-03-22","2022-03-23","2022-03-24","2022-03-25","2022-03-26","2022-03-27","2022-03-28","2022-03-29","2022-03-30","2022-03-31","2022-04-01","2022-04-02"]
[null,null,null,44621,44622,44623,44624,44625,44626,44627,44628,44629,44630,44631,44632,44633,44634,44635,44636,44637,44638,44639,44640,44641,44642,44643,44644,44645,44646,44647,44648,44649,44650,44651,44652,44653]
[]
[]
[null,null,"入力規則用"]
[null,null,2020,1]
[null,null,2021,2]
[null,null,2022,3]
[null,null,2023,4]
[null,null,2024,5]
[null,null,2025,6]
[null,null,2026,7]
[null,null,2027,8]
[null,null,2028,9]
[null,null,2029,10]
[null,null,2030,11]
[null,null,2031,12]

{"sheet":"param","index":2,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["設定パラメータ"]
[]
["メール設定"]
[]
["添付ファイル（日報）保存用エリア"]
["送信ファイルの保存先","C:\\senddata_vba"]
["保存基礎名（編集可）","業務日報"]
["メール設定"]
["送信者表示","（株）架空工業　吉田二郎"]
["メール表題",{"$f":"\"（株）架空工業_\"&TEXT(TODAY()-1,\"yyymmdd\")&\"日報\"","v":"（株）架空工業_20220519日報"}]
[null,"メールあて先"]
["to","acount01@samplesite.com"]
["cc","acount02@samplesite03.com"]
["bcc"]
[null,"文面"]
["宛先名1","山田様"]
["宛先名2","鈴木様"]
["本文",{"$f":"TEXT(TODAY()-1,\"yyy年mm月dd日(aaa)\")&\"の業務日報を送付させていただきます。\"","v":"2022年05月19日(木)の業務日報を送付させていただきます。"}]
[]
[null,"Outlookの制御にMicrosoft Outlook 16.0 Object Library を利用しています"]
[null,"（PC環境によりバージョンが異なる場合もあります）への参照を設定する必要があります。）"]
[null,"VBAの画面から、「ツール」->「参照設定」"]