In YouTuber Randy Austin's video he shows how to create the same xlsm workbook as I do here, but he uses Visual Basic Scripts. In my demo I rewrote his script into Powershell this showing how it is possible to do the same tasks as Visual Basic Scripts.
Source: Randy Austin's Blog Page: https://www.excelforfreelancers.com/c...
GitHub Repo: https://github.com/MrAnalyticals/Exce...
Microsoft is Deprecating Visual Basic Scripts
Modern Alternatives: Microsoft advocates transitioning to more capable and secure tools—namely PowerShell for automation and administrative tasks, and JavaScript for web-related functions
On this page of the site you can watch the video online Use one PowerShell script to create a fully functioning Excel VBA Database!! with a duration of hours minute second in good quality, which was uploaded by the user Analysis Cloud IT Vlog 28 August 2025, share the link with friends and acquaintances, this video has already been watched 252 times on youtube and it was liked by 3 viewers. Enjoy your viewing!