How Can I pass multiple VBA variables into a called Powershell script?

Question

Can I pass a VBA variable into a called Powershell script?.

With the help of the above post, I am able to pass one variable to PowerShell. I need to pass two variables, there I failed with the below script. Can someone please help me with it.

strCommand = "powershell -ExecutionPolicy Unrestricted  -file `\""C:\Users\n3540551\Desktop\cluster\remote.ps1`\"" -name `\""" & nameVariable & "`\"" -pass2 `\""" & passVariable & "`\"""

PowerShell script as below:-

param([string]$name)
param([string]$pass2)
$MyUserName = "cctv";
$MyPassword = ConvertTo-SecureString $pass2 -asplaintext -force;
$MyCredentials2 = new-object -typename System.Management.Automation.PSCredential `
-argumentlist $MyUserName,$MyPassword

$scriptblock = {if ((Select-String -Path "C:\ProgramData\Root.1.log" -Pattern "Mismatching SRP verifier") -ne $null){echo "Mismatching SRP verifier found. Please check File"}else{ echo "All Goood!"}}

 Invoke-Command -ComputerName $name -credential $MyCredentials2 -ScriptBlock $scriptblock

What does your powershell script look like? We’d have to guess to help. — Doug Maurer
– Doug Maurer, Commented Jan 6, 2022 at 5:37
You only need one param block. Param([string]$name,[string]$pass2) — Doug Maurer
– Doug Maurer, Commented Jan 6, 2022 at 9:43

Mathias R. Jessen · Accepted Answer · 2022-01-06 10:51:06Z

0

The PowerShell parser only recognizes 1 param statement per block, so you need to change:

param([string]$name)
param([string]$pass2)

to

param(
  [string]$name,
  [string]$pass2
)

answered Jan 6, 2022 at 10:51

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

1 Comment

colorstt Over a year ago

Thanks a lot. that was the perfect fix.

Collectives™ on Stack Overflow

How Can I pass multiple VBA variables into a called Powershell script?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related