VBA Automation Project || Build a Worksheet to Control the Flow of a Macro || Lots of Tips & Tricks

Learn how to control a macro from the Excel worksheet.

In this video, we configure the Excel front-end i.e. a worksheet, from where we can control various elements of a reporting macro. The idea is to build this macro for a third-person user and give them the ability to:
- input various details such as folder path to pick up file from
- run the macro in individual steps or run in one flow
- and, trouble-shoot errors (themselves) that occur due to incorrectly entered details in the input areas.

There will be a huge emphasis on error handling.

You will find a lot of tips and tricks all along within this video, such as:
- how to use Radio Option buttons
- how to use Enums
- how to send an email based on details entered on a worksheet.
- how to split the email subject onto various lines.
- how check if a file or folder exists on our computer drive.
- how to validate a file name and check for extension.
- how to validate email addresses

The blank and completed macro file is loaded to Github:
https://github.com/skillsandautomatio...

You can even, grab the code from my blogsite:
https://skillsandautomation.com/proje...

00:00 Intro
00:45 Demo
05:32 (Part 1) Build Console Template
10:51 (Part 1) Code the Toggle Logic
23:18 (Part 1) Import File
25:19 (Part 1) Transform & Export Data
33:26 (Part 1) Send Email
42:31 (Part 2) Error Handling - Basic Design
54:42 (Part 2) Error Handling - Files & Folders
1:11:53 (Part 2) Error Handling - Email Validation

#excelvba