I'd say they are doing this because of LLMs, so that normal users can tell Excel what it should be doing, and it then generates a script which can execute it.