{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Header Sheet","List Modules","List Procedures"],"not_rendered":{"charts":0,"images":1,"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":"Header Sheet","index":0,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[20,1,20,3],[22,1,22,3],[28,1,28,3],[30,1,30,3],[24,1,24,3],[26,1,26,3],[1,2,1,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[18,1,18,3]]}
[]
[null,null,"Visual Basic Integrated Design Environment (VBIDE)"]
[]
[null,"Document Number :  ","VBIDE"]
[null,"Owner / Author :  ","Thomas James Rowe"]
[null,"Last Update :  ","2022-01-28"]
[]
[null,"Purpose and Objectives"]
[]
[null,"Visual Basic Integrated Design Environment (VBIDE) programming."]
[]
[null,"Worksheets"]
[]
[null,"List Modules","List of Modules in Project."]
[null,"List Procedures","List of Procedures in Project."]
[]
[null,"Other Relevant Information"]
[]
[null,"What is VBIDE ?\nVBIDE is the acronym for the Visual Basic Integrated Design Environment.\nThis library is often referred to as the VBIDE object library\nThe library allows you to write code in VBA that reads or modifies other VBA projects, modules, or procedures."]
[]
[null,"Microsoft Visual Basic for Applications Extensibility 5.3\nThis is the VBIDE object library that defines all the objects and values that make up VBProject and the Visual Basic Editor. The library must be referenced  to use the VBA Extensibility objects."]
[]
[null,"The VBIDE Object Model\nThe VBIDE object model consists of the following parts.\n\nVBEditor\nVBProject – This is holds all of the code modules in a given Office document.\nVBComponent – A “wrapper” around a given code module.\nCodeModule – The actual place where the code in a given component is stored and accessed from.\n\nEssentially, VBProject and VBComponent allow us to access the code module while CodeModule enables the accessing of the code inside it."]
[]
[null,"Chip Pearson - Programming The VBA Editor\nA large part of of code in this workbook has been adapted specifically to pass variables to the subroutines so that they are reusable, from the late Chip Pearson's article on 'Programming The VBA Editor'."]
[]
[null,"http://www.cpearson.com/excel/vbe.aspx"]
[]
[null,"Microsoft - Visual Basic add-in model reference"]
[]
[null,"https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/visual-basic-add-in-model-reference"]
[]
[null,"Revision Log"]
[]
[null,"Date","Amendments  ","Updated by"]
[]
[]
[]
[]
[null,"Copyright © 2022 Thomas James Rowe (Excel Coding) All Rights Reserved"]

{"sheet":"List Modules","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["ThisWorkbook","Document Module"]
["wsHeader","Document Module"]
["modVBIDE","Code Module"]
["modTestVBIDE","Code Module"]
["wsListModules","Document Module"]
["wsListProcedures","Document Module"]
["modObfuscation","Code Module"]
["frmObsfuscation","UserForm"]
["modClass","Class Module"]

{"sheet":"List Procedures","index":2,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["ColumnIndex","Sub Or Function"]
["ColumnLetter","Sub Or Function"]
["IsLetter","Sub Or Function"]
["LastRow","Sub Or Function"]
["LastCol","Sub Or Function"]
["AddCodeToModule","Sub Or Function"]
["AddModuleToProject","Sub Or Function"]
["AddProcedureSayHelloToModule","Sub Or Function"]
["blnIsEditorInSync","Sub Or Function"]
["blnCopyModule","Sub Or Function"]
["blnExportVBComponent","Sub Or Function"]
["blnVBComponentExists","Sub Or Function"]
["ComponentTypeToString","Sub Or Function"]
["CreateEventProcedure","Sub Or Function"]
["CreateProcedure","Sub Or Function"]
["DeleteAllVBACode","Sub Or Function"]
["DeleteModule","Sub Or Function"]
["DeleteProcedureFromModule","Sub Or Function"]
["EliminateScreenFlicker","Sub Or Function"]
["GetFileExtension","Sub Or Function"]
["GetProcedureDeclaration","Sub Or Function"]
["ListModules","Sub Or Function"]
["ListProcedures","Sub Or Function"]
["ProcedureInformation","Sub Or Function"]
["strProcedureKindString","Sub Or Function"]
["ProcedureScopeString","Sub Or Function"]
["RenameModule","Sub Or Function"]
["SearchCodeModule","Sub Or Function"]
["ShowProcedureInfo","Sub Or Function"]
["strSingleSpace","Sub Or Function"]
["SyncVBAEditor","Sub Or Function"]
["TotalCodeLinesInProject","Sub Or Function"]
["TotalCodeLinesInVBComponent","Sub Or Function"]
["TotalLinesInProject","Sub Or Function"]
["VBIDEReferenceObjects","Sub Or Function"]
["WorkbookOfVBProject","Sub Or Function"]