excel vba macro recorder to parse text using text to columns vba excel
Why experts use the Excel VBA macro recorder to get programs built quickly.
Excel VBA book (affiliate) with reviews https://amzn.to/3axlqih
In this video, I discuss why professionals use the VBA macro recorder from time to time and how you can speed up your understanding of the Excel Application Programming Interface by using it to see how Excel handles complicated stuff.
I use the VBA macro recorder to parse text from a website using excel text to columns, I then review the recorded VBA text to columns code and compare it against the Microsoft Documentation and manually enhance the code.
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson
☕
I'll then use the macro recorder code in a small program written from scratch.
It's worth going through this video because you'll pick up some useful tips and tricks along the way.
Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum
Microphones
---------------
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm : https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b
Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh
Note Taking
--------------
Rocketbook reusable notebook https://amzn.to/3sSK3xg
#excelvba #excelmacro
