VBA Macros vs Office scripts intro: New in 2023

Microsoft just launched Office Scripts. A new scripting language that can be used to replace what VBA has always done. Here I compare and contrast the two products, their script recorders, their code editors, which versions they work on plus where they do and don't work. We go through several examples to compare including formatting cells, building charts, relative and absolute referencing, charts as well as exploring if/then clauses plus how to create buttons inside workbooks. For the features you cannot do natively with the script recorder, I go through where you can find resources for more information, on either Excel or Excel Online and I run through the complex versioning which you need to know for both tools.
MS Online documentation: learn.microsoft.com/en-us/off...
To follow what is new in Excel, check out the official Excel monthly blog I help write here: techcommunity.microsoft.com/t...
And the newsletter I co-author here: solveandexcel.ca/excel_news/
Example files can be found here: www.xlconsulting-asia.com/youtube-files
Power Query intro: • Power Query: 4 min int...
00:00 Script recorder
01:08 Assign to a button/shape
01:51 Relative referencing (Macros)
02:35 Record macro
04:03 Record both at same time
06:04 Comparing code side by side
06:52 Redundant code
10:22 Personal macro workbook
12:20 Macro security
12:45 Reusing Office scripts
13:08 Comparison of features
16:43 Excel Online and storing scripts
18:24 Office Scripts over VBA? Now & in future

[@MCA-trader-]

David Benaim is an excellent practitioner and teacher of MS Excel and much more. I thank him again for the recent course, it was very useful. All the best!

[@learnspreadsheets]

That’s very kind! Thanks 😃

[@antique-bs8bb]

I really appreciate this - great simple examples, great comparisons with VBA, great summary of where we are now and may be going.
Thanks.

[@learnspreadsheets]

Thanks for the kind words! Glad you liked it 😃

[@sandeepkothari5000]

Long Live VBA!

[@learnspreadsheets]

Indeed!

[@johannpenner5548]

Hi David, I'm trying in vain to create sections and pages via Excel vba via API in onenote sections. If you don't have any ideas for your content and are familiar with the matter, I would be very interested.

[@learnspreadsheets]

Hiya sorry it sounds cool but I don’t know how to go about with that

[@MCA-trader-]

David Benaim is an excellent practitioner and teacher of MS Excel and much more. I thank him again for the recent course, it was very useful. All the best!

[@learnspreadsheets]

Thanks so much! It was a pleasure teaching you 😃