{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["List_PDF","Using_FileSystemObject","List_Custom_Function","Do_While_Specific_Extension","List_Files_Folder_Sub_Folder","List_Any_Extension"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"List_PDF","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Creating List of PDF Files"]
[]
[null,"File Name","Location"]
[null,"ExcelDemy_Basics.pdf","C:\\ExcelDemy\\"]
[null,"Softeko_Regulation.pdf","C:\\ExcelDemy\\"]
[null,"VBA_Notes.pdf","C:\\ExcelDemy\\"]

{"sheet":"Using_FileSystemObject","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Getting Specific File Names Using VBA FileSystemObject"]
[]
[null,"File Names"]
[null,"ExcelDemy_Basics.pdf"]
[null,"Softeko_Regulation.pdf"]
[null,"VBA_Notes.pdf"]

{"sheet":"List_Custom_Function","index":2,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Creating List of xlsx Files Using Custom Function"]
[]
[null,"xlsx File Lists",{"$f":"List_Function(\"C:\\ExcelDemy\\\",\"xlsx\")","v":"Change Document Properties.xlsx"},"Mortgage Calculation.xlsx","Reverese Mortgage Calculation.xlsx"]

{"sheet":"Do_While_Specific_Extension","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Do While Loop for xlsm Extension"]
[]
[null,"File Name"]
[null,"Giving Break while Running Macro.xlsm"]
[null,"Table Transpose with VBA.xlsm"]
[null,"VLookup with VBA.xlsm"]

{"sheet":"List_Files_Folder_Sub_Folder","index":4,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["Getting File Names in Folder & Sub-Folder"]
[]
["Path","Folder","File Name","Is Hidden"]
["C:\\ExcelDemy\\ExcelDemy_Basics.pdf","C:\\ExcelDemy","ExcelDemy_Basics.pdf",false]
["C:\\ExcelDemy\\Softeko_Regulation.pdf","C:\\ExcelDemy","Softeko_Regulation.pdf",true]
["C:\\ExcelDemy\\VBA_Notes.pdf","C:\\ExcelDemy","VBA_Notes.pdf",false]
["C:\\ExcelDemy\\VBA\\ExcelDemy_Notes.pdf","C:\\ExcelDemy\\VBA","ExcelDemy_Notes.pdf",false]

{"sheet":"List_Any_Extension","index":5,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"List of Files of Any Extension"]
[]
[null,"File","Type","File Path"]
[null,"Copy and Paste with VBA.xlsm","xlsm","C:\\ExcelDemy\\VBA\\"]
[null,"ExcelDemy_Notes.pdf","pdf","C:\\ExcelDemy\\VBA\\"]
[null,"Range Selection in Excel.xlsx","xlsx","C:\\ExcelDemy\\VBA\\"]
[null,"Change Document Properties.xlsx","xlsx","C:\\ExcelDemy\\"]
[null,"ExcelDemy_Basics.pdf","pdf","C:\\ExcelDemy\\"]
[null,"Giving Break while Running Macro.xlsm","xlsm","C:\\ExcelDemy\\"]
[null,"Mortgage Calculation.xlsx","xlsx","C:\\ExcelDemy\\"]
[null,"Personal_Growth.docx","docx","C:\\ExcelDemy\\"]
[null,"Reverese Mortgage Calculation.xlsx","xlsx","C:\\ExcelDemy\\"]
[null,"Softeko_Regulation.pdf","pdf","C:\\ExcelDemy\\"]
[null,"Table Transpose with VBA.xlsm","xlsm","C:\\ExcelDemy\\"]
[null,"VBA_Notes.pdf","pdf","C:\\ExcelDemy\\"]
[null,"VLookup with VBA.xlsm","xlsm","C:\\ExcelDemy\\"]