Use one PowerShell script to create a fully functioning Excel VBA Database!!
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