Using the add-in, you work with high-level methods while the add-in loads configurations from a database.
So, you can create applications completely using VBA from empty workbooks like in this book.
' Creates the application worksheets, Chapter 21 Sub Chapter21_1_CreateApplication() Call Chapter02_2_CreateMasterTableEditors() Call Chapter05_1_CreatePaymentsWorksheet() Call Chapter06_1_SetPaymentsWhereParameters() Call Chapter07_1_SetLanguage() Call Chapter09_1_CreateTableViews() Call Chapter11_1_CreateReportsWorksheet() Call Chapter13_1_ChangeQueryObject() Call Chapter14_1_SaveChanges() Call Chapter15_1_AddCursors() Call Chapter15_2_AddCursorButtons() Call Chapter16_1_AddFormFields() Call Chapter17_1_CreateCompanyPaymentsWorksheet() End Sub
When you remove an application, remove the add-in data sheets using the last three methods:
' Removes the application worksheets, Chapter 21 Sub Chapter21_2_RemoveApplication() If Not MsgBox("Are you sure to delete all worksheets?", vbYesNo) = vbYes Then Exit Sub Dim wb As Workbook Set wb = ActiveWorkbook Call DeleteWorksheet(wb, "CompanyPayments") Call DeleteWorksheet(wb, "Reports") Call DeleteWorksheet(wb, "Payments") Call DeleteWorksheet(wb, "Accounts") Call DeleteWorksheet(wb, "Companies") Call DeleteWorksheet(wb, "Items") Dim addIn As Object Set addIn = GetAddInAndCheck() If addIn Is Nothing Then Exit Sub Call addIn.DeleteAllTableViews(wb) Call addIn.DeleteAllTableCursors(wb) Call addIn.DeleteAddInSheets(wb) ' The workbook must contain the start sheet only End Sub