Use VBA To Run a Powershell Command and Get Return Value

Опубликовано: 24 Октябрь 2024
на канале: SyntaxByte
9,119
61

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...