PowerShell is a command-line shell and scripting language built into Windows that can help you automate administrative and repetitive tasks. If you've used it before, it might already feel familiar.

Launching a PowerShell Script from Excel, Revisited. ... As you can see, cell B1 contains the value of 5, which it received from PowerShell. [Click on image for larger view.] Figure 2.

Windows PowerShell ISE is a GUI-based application. You can use it to wite, run, and edit multiple scripts and commands in different tabs.