Hide powershell window while executing script

Question

I am newbie at using Powershell and scripts .. In script file there are simple commands that I would like to run and everything is ok

Sub TestUDF()
MsgBox ScriptFile
End Sub

Function ScriptFile() As String
Dim wshShell        As Object
Dim wshShellExec    As Object
Dim strCommand      As String
Dim strOutput       As String

strCommand = "Powershell -File ""C:\Users\Future\Desktop\Test.ps1"""
Set wshShell = CreateObject("WScript.Shell")
Set wshShellExec = wshShell.Exec(strCommand)
strOutput = wshShellExec.StdOut.ReadAll

ScriptFile = strOutput
End Function

My problem is that when running the code, the powershell window appears for two seconds. How can I hide it so as not to display this window at all?

user847990 · Accepted Answer · 2019-08-05 05:48:32Z

3

You would add an additional parameter on your command to call PowerShell to keep the window hidden. Adjust the strCommand to something like this:

strCommand = "Powershell -WindowStyle Hidden -File ""C:\Users\Future\Desktop\Test.ps1"""

answered Aug 5, 2019 at 5:48

user847990

Sign up to request clarification or add additional context in comments.

2 Comments

YasserKhalil Over a year ago

Thank you very much. I tried this parameter -WindowStyle Hidden and also -nologo but the window appears for a second ...

user847990 Over a year ago

I would say then it is something Excel is overwriting the normal behavior. Nothing you can do about that, that I'm aware of.

Collectives™ on Stack Overflow

Hide powershell window while executing script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related