Open a file from VBA

[anichols]

Hello all,

I found this online, and I think it is very close to what I am trying to do, but haven't had much luck in adjusting it to my needs. I am just looking for a way for VBA to open a file. In this case a .PS1 file.

Sub RunAndGetCmd()

    strCommand = "Powershell -File ""C:\Users\drew\Desktop\showDSKTP.ps1"""
    Set WshShell = CreateObject("WScript.Shell")
    Set WshShellExec = WshShell.Exec(strCommand)
    strOutput = WshShellExec.StdOut.ReadAll
    'MsgBox strOutput

End Sub

Any help would be greatly appreciated.

 

[Logit]

See if this works ...

Sub test()
'Call Powershell and run scripts
Call Shell("powershell -noexit -file ""C:\Users\drew\Desktop\showDSKTP.ps1", vbMaximizedFocus)
End Sub


Calling a PS script from VBA

 

[rhombus4]

Does this work ?

ActiveWorkbook.FollowHyperlink "C:\Users\drew\Desktop\showDSKTP.ps1"