Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Here is the VBA I have:
$ADUser = get-aduser $args $strUser = $ADUser.SurName + ", " + $ADUser.GivenName return $strUser
The MsgBox displays a number and not lastname, firstname.
Sub test() retval = Shell("powershell.exe C:\Documents\Templates\NameLookup.ps1 " & Sheet(4).Cell(6,1).Value, 1) MsgBox (retval) End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.