Introduction

Excel AppMaker is an advanced Excel-based tool that transforms how you interact with VBA by allowing the dynamic creation of customized forms, workflows, reports, and dashboards. While technically a sophisticated spreadsheet, its powerful VBA programming enables the configuration of interfaces that resemble standalone applications, offering a seamless and professional experience within Excel.

The magic of Excel AppMaker is that it automatically handles all database connections and management tasks. It creates and updates Microsoft Access database tables behind the scenes, so users don’t have to worry about technical details. You can easily design data entry forms, build interactive dashboards, and set up workflows, all linked to a database—without writing a single line of code.

Whether you need to create fully customized interfaces tailored to your specific business processes, monitor performance metrics, or automate business processes, Excel AppMaker makes it simple. Just use the easy-to-follow menus and forms to build your application, and the system takes care of connecting everything to the database, ensuring your data is stored and managed securely.

This means that with Excel AppMaker, anyone can build a professional, data-driven application tailored to their needs, without needing to know how to code or manage a database.

The Excel AppMaker offers more than just a tool for building applications—it’s a powerful resource for anyone looking to deepen their understanding of Excel VBA programming. Along with its core functionality, the app provides an extensive online manual that guides users through configuring interfaces, reports, dashboards, and automating data exports.

The application’s VBA code is completely open, offering users the chance to explore advanced, real-world applications of VBA. This includes interfaces for tracking changes across different versions, allowing developers to review modifications using Bitbucket as a version control system.

Creating an interface with two tabs (Employee and Dependents)

In this video we will implement an interface with two tabs using the Excel AppMaker. In addition, we will show you how to create a report and also a script to avoid accidental deletion of records. Finally, we will explain how to install an extension (add-on) that implements the entire example discussed.

Implementing the 8D Problem-Solving Methodology with Excel AppMaker

If you’re familiar with the 8D methodology (8 Disciplines), you know it’s a structured approach to solving complex problems by identifying root causes and preventing recurrence. Widely used in various industries, the 8D process helps teams not only tackle immediate issues but also implement long-term solutions that drive continuous improvement.

I’ve been working on a practical solution to make the 8D process easier to manage: Excel AppMaker. It’s a fully automated, Excel-based tool designed to help you implement the 8D methodology with zero cost. Yes, it’s completely free to download and use.

Here’s what makes it different:
✅ Automated Database Integration: All the information you enter into the 8D form is automatically saved in a database created by the tool. This allows multiple users to work simultaneously without data conflicts—a huge advantage over standard spreadsheets.

✅ Rich Documentation: You can attach files like photos, videos, Word docs, and more directly into the 8D report, so you’re not limited to text alone. This helps capture the full context of the problem and its resolution.

✅ Detailed Dashboards: Keep track of your progress with an easy-to-read dashboard that shows key metrics for each 8D report.

✅ Customizable without Coding: Even if you’re not a programmer, you can tailor the tool to your specific needs. With Excel AppMaker’s built-in tools, you can modify forms and workflows without touching the VBA code.

✅ Secure Access Control: Manage users with a built-in login system, ensuring only authorized people can access or modify data.

Since all data is stored in a database (not the spreadsheet), you’ll have the flexibility to store more information and work more collaboratively.

Feel free to download it and see how it can make your 8D problem-solving process more efficient and collaborative.

Create process flow in a user interface (UI) without coding, using just flowcharts

Usually when creating a user interface, it is also necessary to create some kind of flow or rules that determine how the user will interact with that interface.

This video uses as an example an interface for requesting services where 3 actors interact with the interface.

Initially, the requestor creates a record requesting some type of service. Subsequently, this request is sent to a coordinator who will direct it to a technician in order to perform the task or return it to the requester if there is any inconsistency in the information. The technician in turn is the one who ends this process by completing the task.

The implemented flow specifies when each actor will be able to edit the request data, as well as determines which fields each one will have access to.

The video demonstrates how to add this flow without coding, using a flowchart-only-based technique.