Execute a .exe with arguments from VBA macro in Excel

Question

I want to write a VBA macro to execute the following DOS command (verified, works) by pressing a button in excel:

powershell.exe -command "Get-ADGroupMember -identity "Sec_Tc_RWaccess" -Recursive | Get-ADUser -Property userPrincipalName, Enabled| Select userPrincipalName, Enabled | Export-csv -path C:\temp\textfile.csv"

My idea was to use the function:

Shell (Program,WindowStyle)

but I don't manage to pass the arguments to powershell.exe

What did you try? Any quotes within the Program string need to be doubled. — Rory
– Rory, Commented Feb 14, 2019 at 14:15

Marcell Toth · Accepted Answer · 2019-02-14 14:39:33Z

1

Welcome to StackOverflow!

I would run something like this (untested):

Sub test()
    Call Shell("powershell -command ""Get-ADGroupMember -identity ""Sec_Tc_RWaccess"" -Recursive | Get-ADUser -Property userPrincipalName, Enabled| Select userPrincipalName, Enabled | Export-csv -path C:\temp\textfile.csv""", vbMaximizedFocus)
End Sub

Please amend your question by including the exact code you are trying to run. That helps us (and other people who have the same problem) a lot.

answered Feb 14, 2019 at 14:39

Marcell Toth

3,6981 gold badge24 silver badges37 bronze badges

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

1 Comment

user11062429 Over a year ago

thanks a lot. these double quotes solved my problem.

Collectives™ on Stack Overflow

Execute a .exe with arguments from VBA macro in Excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related