There’s a moment…
in almost every Excel user’s journey…
where they believe…
they’ve discovered automation.
They record a macro.
They press play.
And for a brief moment…
it feels like magic.
But what if…
that moment…
is also the beginning…
of a misunderstanding?
THE COMMON BELIEF
When asked about the difference…
between a macro…
and VBA…
most people give the same answer.
A macro…
is something you record.
VBA…
is what happens…
when you modify it.
Simple.
Logical.
Widely accepted.
And according to Hiran de Silva…
almost entirely missing the point.
THE STORY BEGINS
So instead of arguing…
he tells a story.
Not about Excel.
About a car.
THE RECORDED JOURNEY
Imagine…
you drive to work every morning.
Same route.
Same turns.
Same routine.
Now imagine…
your car…
records everything you do.
Every decision.
Every stop.
Every movement.
And the next day…
you decide not to drive at all.
You simply press…
play.
Why you sit in the driver’s seat reading the newspapers.
THE BREAKDOWN
At first…
everything seems fine.
Until…
it isn’t.
The car turns…
when traffic is coming.
It ignores a pedestrian…
because yesterday…
there wasn’t one.
It stops at a green light…
because yesterday…
it was red.
And when the road ahead is closed…
it drives straight into it.
THE QUESTION
Hiran pauses here…
and asks something deceptively simple.
Is that…
a viable system?
A REAL-WORLD PARALLEL
In 1971…
on BBC Tomorrow’s World…
presented by Michael Wood…
a new kind of navigation system…
was demonstrated.
It used cassette tapes.
Pre-recorded journeys.
Instructions played back…
based on distance travelled.
It was innovative.
It was clever.
And it had the exact same flaw.
THE LIMITATION
Because the world…
doesn’t stay the same.
Roads close.
Traffic builds.
Conditions change.
And a system…
that replays yesterday…
fails…
today.
THE SHIFT
Now fast forward.
Modern satellite navigation systems…
don’t replay journeys.
They interpret them.
They monitor traffic.
They detect disruption.
They recalculate…
in real time.
And then…
we go one step further.
THE INTELLIGENT SYSTEM
Self-driving cars.
Not following instructions.
But observing.
Evaluating.
Deciding.
They don’t ask:
“What happened yesterday?”
They ask:
“What’s happening now?”
THE REVEAL
And this…
is where Hiran brings it back…
to Excel.
Because what what most people think…
is the difference…
between macros and VBA…
isn’t the real difference at all.
THE TRUTH
Recording a macro…
is replaying yesterday’s journey.
Even modifying it…
is still editing the tape.
But programming…
is something else entirely.
It is not a sequence.
It is a system. A system of observation, figuring out, appropriate action.
THE SECOND ANALOGY
He offers one more example.
Music.
A classical piece…
like Chopin.
Every note is written.
You follow it exactly.
Now compare that…
to improvisation. Like what jazz musicians do.
Listening.
Responding.
Adapting.
Not following instructions…
but engaging with reality of now. Not where Chopin was more than a century ago.
THE HIDDEN LAYER
And then…
the part almost no one talks about.
Macro recording…
only captures…
what you can physically do.
Click.
Type.
Select.
But the real power of Excel…
exists somewhere else.
In when Excel leverages databases.
In systems.
In connections.
In places…
you cannot record.
Only imagine. Only design.
Only program.
THE CONCLUSION
So in the end…
the distinction is not technical.
It is philosophical.
A recorded macro…
replays yesterday.
Programming…
handles today and, more importantly, tomorrow.
FINAL LINE (PAUSE)
And once you see that…
you realise…
these are not two versions…
of the same thing.
They are…
two completely different worlds.
Add comment