1

I'm running below lines in VBA in Access

cmd = "powershell -ExecutionPolicy Bypass -Command ""&{. 'C:\Users\chb8wz\Desktop\users.ps1';countLines -logFile '" & fname & "'}"""
Shell cmd

The script "users.ps1" returns the value of number of user from particular OU:

$Users = (Get-ADUser -Filter * -SearchBase "ou=Useraccounts").count

How can I save the value of users (e.g powershell returns 200) to a variable in VBA?

Improve this question
0
Related questions
1103
How to run a PowerShell script
582
Terminating a script in PowerShell
620
How can I pass an argument to a PowerShell script?
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.