Run PowerShell command in VBA

Question

I am trying to run the PowerShell command Test-Path in VBA. But I cannot get it to work. I want to check if a file exists on a remote computer or on a NAS. The DIR function does not work. Here is the VBA code that I am using.

Dim boolFileExists as Boolean

boolFileExists = "PowerShell -Command ""{Test-Path 'D:\Data\Exercise\Chair Workouts.docx'}"""

Thank you

Why using powershell in VBA for that? Please use "Scripting.FilesystemObject" to determine whether a filesystem item exists or not. With powershell you only get some text returned which needs to be parsed. No methods available. learn.microsoft.com/de-de/office/vba/language/reference/… — swbbl
– swbbl, Commented Sep 25, 2020 at 15:02
Agree with @pwndsh. I presume VBA is going to complain if you are trying to run an outside executable. That strikes me as a rather intolerable attack vector. — Steven
– Steven, Commented Sep 25, 2020 at 15:37
Thank you, I was able to run the PowerShell command, but I was not able to get a return value. I took pwndsh's advice to use the Scripting.FilesystemObject. It worked perfectly. Thank you very much. — Jerry
– Jerry, Commented Sep 29, 2020 at 15:35

baka_toroi · Accepted Answer · 2020-09-25 16:02:52Z

0

The comments are right but if you want to use Powershell you need to use VBA's Shell command to do it: PowerShell Command from VBA

answered Sep 25, 2020 at 16:02

baka_toroi

746 bronze badges

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

1 Comment

Jerry Over a year ago

Thank you, I was able to run the PowerShell command, but I was not able to get a return value. I took pwndsh's advice to use the Scripting.FilesystemObject. It worked perfectly. Thank you very much.

Collectives™ on Stack Overflow

Run PowerShell command in VBA

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related