{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Data","Report","Wrap Up"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"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":"Title","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2213]

{"sheet":"Data","index":1,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Product"]
["Apple"]
["Banana"]
["Cherry"]
["Date"]
["Elderberry"]
["Fig"]
["Guava"]
["Honeydew"]
["Iceberg"]
["Jackfruit"]
["Kiwi"]
["Lime"]

{"sheet":"Report","index":2,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["MrExcel Report for"]
["Apple"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5","Total"]
["Revenue",null,null,null,null,null,{"$f":"SUM(B5:F5)","v":0}]
["Cost",null,null,null,null,null,{"$f":"SUM(B6:F6)","v":0}]
["Commission",null,null,null,null,null,{"$f":"SUM(B7:F7)","v":0}]
[]
[{"$f":"RAND()","v":0.35940192545152383},0.15725925697644838,0.43253583926787098,0.25489177104883431,0.84402858183170149,0.86832105263385317,0.51415519751032945]
[0.48535071911778449,0.2976814275029287,0.36374053968860642,0.98421301757472035,0.91933173145522695,0.91782743183653936,3.203735643703487E-2]
[0.11408841286883675,0.89068513703269359,0.10013747682990115,0.97105307976065569,2.6288577162397408E-2,0.93380302199729481,0.86811063137900746]
[0.41714815529912341,0.70311703443728479,0.7371224010418187,0.2337987721761341,0.3896232612214019,0.78255452908158563,0.87172886467767818]
[0.10006948911222668,0.98769761690757207,0.49878686062306021,0.62541819844012192,3.3145736261626757E-2,0.37402416912023129,0.86270391610994979]
[0.62291322675606764,0.30699128316880664,0.53361956089213258,0.57700638990143505,0.64799413318290433,0.37643111468931101,0.12165590522606273]
[0.51750042894881032,9.2519826033072405E-2,0.63490837300499015,0.13663159263880942,0.4114058514574056,0.14489731299631192,0.94793681344614522]
[0.61925484098381267,0.38276572858911029,0.57936433069341087,0.54452929352496515,0.85283636158990195,8.379698691471027E-2,0.52726203942424088]
[0.43416335669603101,0.53857281999374074,0.17331890251785831,0.50768483684453303,0.68293981763331091,0.11737332031862779,0.39737866224558671]
[0.80676903253396415,0.48682181405196467,0.11089895460882326,7.7904306552470381E-2,0.12692928421871896,0.69624343866042848,0.2152236216378961]
[0.74481326230996237,0.61627623479036053,0.16632727581503592,0.51239571310416632,0.7540383204908172,0.44719373971923859,0.65607959345239253]
[0.56375480050468263,2.2739552854217804E-2,0.21830820180485144,0.65562042018578204,0.3713172881805209,0.54323015555791421,0.23623429466904466]

{"sheet":"Wrap Up","index":3,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"You want VBA to write several copies of the current workbook"]
[null,"SaveAs causes problems, because the original workbook is no longer open"]
[null,"Instead use .SaveAsCopy to save a copy of the workbook"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"To download this workbook: https://www.mrexcel.com/download-center/2018/05/save-as-keeping-original-open.xlsm"]
[null,"List of upcoming seminars: https://www.mrexcel.com/press-appearances/"]
[]
[null,"To download the workbook from today's video, visit the URL in the YouTube description"]
[]
[null,"Title Image Photo Credit: Photo by Andrew Bui on Unsplash"]