"Our Office Scripts team is investigating ways we can improve .....!!!!!"
Nice to know NancyatMSFT - Just curious to know if the VBA Team is also looking as ways to improve - or are they content with occasional updates to the object model any time a new feature gets added by the other teams - or have they give up hope and have become a 2 member team sitting in the basement of some office building
If they are looking for inspiration to bring the VBE IDE in to the current century look at Mathieu Guindon's Rubberduck -https://rubberduckvba.com/ and see how one man's brilliance far outshines the might of a cash rich organization like M$
Need more inspiration look for Govert's work on https://excel-dna.net/
This is just to name a few
Now compare it with with improvements done to the VBE by the VBA Team in the last 15 Years - Approx ZERO
We cant even do basic stuff like Zoom, indent the code, export /import modules in Bulk - and this list goes on and on and on.
And you now you ask us "----If you use automations in your spreadsheets. !!!!" - The Question that you should be asking is does the Leadership in the Excel Team have the vision to look at Excel as a Serious Development platform like they use to in 2002 - When We have a "Developer Edition" of Office - Before the UI Astronauts took over in 2007
Cheers
Sam