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.

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.

☕
☕

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
===============

Microphones
---------------

Video Kit
-------------
Lights

Note Taking
--------------

#excelvba #excelmacro

[janezklun]

Just great video, explanation and useful approach with macro recorder, thank you for sharing, Cheers

[kyasoubi]

very interesting! could you describe how to turn it into a function which can get a value from cell and split it into multipe column?