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: https://learn.microsoft.com/en-us/off...
To follow what is new in Excel, check out the official Excel monthly blog I help write here: https://techcommunity.microsoft.com/t...
And the newsletter I co-author here: https://solveandexcel.ca/excel_news/
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/soc...
Power Query intro:    • Power Query: 4 min intro to Excel's tool t...  

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