One approach to retrieving the PowerShell response is to simply output the command response to a Text file. Silently Retrieving the PowerShell Response Now the problem with the above is that is opens the PowerShell prompt and makes it visible to the user while the command is executed. PS_GetOutput = CreateObject("WScript.Shell").Exec(sPSCmd).StdOut.ReadAll Public Function PS_GetOutput(ByVal sPSCmd As String) As String ' ? PS_GetOutput("Get-ComputerInfo -Property 'OsName'") ' sPSCmd : PowerShell command to run and return the value/response of ' Purpose : Run a PowerShell command and return the response Luckily for us the WScript Shell object provides us with everything we need with the StdOut (standard output) property and ReadAll Method. The next step is to return the response in the case where one is generated. Now that we know the basics, let’s look at how we could then return the response from PowerShell commands. As such, our procedure becomes '-ĬreateObject("WScript.Shell").Run sPSCmd, 0, True Run we can silently run PowerShell commands. Luckily, there a a small change we can make to avoid this. The issue with the above is that it generates a visible PowerShell window that the end-user will see. Public Sub PS_Execute(ByVal sPSCmd As String)ĬreateObject("WScript.Shell").Exec (sPSCmd) ' PS_Execute "New-Item -Path 'C:\temp\charts\Test\1\2\3\4' -ItemType Directory" ' Can do multiple directories in one call! ' PS_Execute "New-Item -Path 'C:\temp\charts\Test' -ItemType Directory"
' PS_Execute "Copy-Item -Path C:\temp\Book1.xls -Destination C:\temp\charts\Book1.xls -Force" ' Req'd Refs: Late Binding -> none required
' Copyright : The following is release as Attribution-ShareAlike 4.0 International ' Author : Daniel Pineault, CARDA Consultants Inc. PowerShell can simply be called/executed from a standard command prompt using the command powershell -commandĪrmed with this information when can simple use a WScript Shell object to execute the command, thus giving us a simple function along the lines of It turns out that it is very easy to do and very similar to the approach taken in VBA – Get Host IP Address. There are many instances in which we simply want to run a PowerShell command and don’t need to get any response back. Before getting into returning a response, let first look at simply executing a command.
0 kommentar(er)
