VBA Automation Project || Build a Worksheet to Control the Flow of a Macro || Lots of Tips & Tricks
HTML-код
- Опубликовано: 22 июл 2024
- 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:
github.com/skillsandautomatio...
You can even, grab the code from my blogsite:
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 Наука
Thanks a lot for sharing your knowledge. This is usually a big problem for me. Very explicit. Thanks again.
please keep posting video like this video
sure, will take note of that. thanks
Thank you for posting this excellent project on request. I would request you to make videos on Error handlers seprately and Sub Proceesure as well where you pass parameters in sub procesure so that we can understand both topics deeply and clear our doubts. You are doing excellent job for beginners like me. God bless you.
Thanks for your comment. Both Error Handling and Sub/ Functions are on my list of videos to make. I will try and release them within this month.
@@SkillsandAutomation Hello Sir, Eagerly waiting for video on Error Handling and sub/functions
Hi, It will be the next one. Will release it by this weekend.
@@SkillsandAutomation Hello Sir, I hope you are well and healthy, sir waiting for your video on error handlers and sub processure where we use parameters in child sub to call parent sub. also on creating functions as well. Sir please explain all these topics with more clarity.
Hi, working on it now. turned out longer than i expected, hence the delay. will release tomorrow.