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
