{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Power Query","Folder_Doc","Folder_Structure_VBA","Folder_PDF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Power Query","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Export Folder Structure to Excel Using Power Query"]
[]
[null,"Name","Extension","Folder Path"]
[null,"Calculating Alpha & Beta.xlsx",".xlsx","C:\\ExcelDemy\\"]
[null,"ExcelDemy_Notes.pdf",".pdf","C:\\ExcelDemy\\"]
[null,"List Files from Folder.xlsm",".xlsm","C:\\ExcelDemy\\"]
[null,"VBA_Instruction.pdf",".pdf","C:\\ExcelDemy\\"]
[null,"List Files from Folder with Specific Extension.xlsm",".xlsm","C:\\ExcelDemy\\VBA\\"]
[null,"VBA_Notes.pdf",".pdf","C:\\ExcelDemy\\VBA\\"]

{"sheet":"Folder_Doc","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Export Folder Structure from Doc File"]
[]
[null,"Column1"]
[null,"Folder PATH listing"]
[null,"Volume serial number is 2C60-75F1"]
[null,"C:."]
[null,"|   Calculating Alpha & Beta.xlsx"]
[null,"|   ExcelDemy_Notes.pdf"]
[null,"|   List Files from Folder.xlsm"]
[null,"|   output.doc"]
[null,"|   VBA_Instruction.pdf"]
[null,"|   "]
[null,"\\---VBA"]
[null,"        List Files from Folder with Specific Extension.xlsm"]
[null,"        VBA_Notes.pdf"]
[null,"        "]

{"sheet":"Folder_Structure_VBA","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[]
["Utilizing VBA to Export Folder Structure"]
[]
["Path","Folder","File Name"]
["C:\\ExcelDemy\\Calculating Alpha & Beta.xlsx","C:\\ExcelDemy","Calculating Alpha & Beta.xlsx"]
["C:\\ExcelDemy\\ExcelDemy_Notes.pdf","C:\\ExcelDemy","ExcelDemy_Notes.pdf"]
["C:\\ExcelDemy\\List Files from Folder.xlsm","C:\\ExcelDemy","List Files from Folder.xlsm"]
["C:\\ExcelDemy\\output.doc","C:\\ExcelDemy","output.doc"]
["C:\\ExcelDemy\\VBA_Instruction.pdf","C:\\ExcelDemy","VBA_Instruction.pdf"]
["C:\\ExcelDemy\\VBA\\List Files from Folde.xlsm","C:\\ExcelDemy\\VBA","List Files from Folder.xlsm"]
["C:\\ExcelDemy\\VBA\\VBA_Notes.pdf","C:\\ExcelDemy\\VBA","VBA_Notes.pdf"]

{"sheet":"Folder_PDF","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA to Export PDF Name from Folder"]
[]
[null,"PDF Name","File Location"]
[null,"ExcelDemy_Notes.pdf","C:\\ExcelDemy\\"]
[null,"VBA_Instruction.pdf","C:\\ExcelDemy\\"]
[null,"SOFTEKO_Regulalations.pdf","C:\\ExcelDemy\\"]
[null,"VBA_Instruction.pdf","C:\\ExcelDemy\\"]
[null,"Windows_Instruction.pdf","C:\\ExcelDemy\\"]