In this video, I show you how to use VBA, such as in Excel, to run any Powershell command. This is a useful way for VBA to run other programs on the computer, and get information from them in the form of standard output. This can greatly expand the reach of your macros.
Note: If you are having trouble with execution policy errors, try this "powershell -executionpolicy bypass (your_command_here)"
Source code and written tutorial: https://syntaxbytetutorials.com/how-t...