I'm making a script that will write a two-dimensional array to an Excel spreadsheet. The script is meant to be called from within other scripts. An outer loop runs once for every row in the array. An ...

I’m making a new Powershell inventory script. I already have one, but I’m fiddling with the arrays to see if I can make the code a little prettier. I can make variables that have custom members with ...

The script will get an xlsx file from the parameters or open a file dialouge if none is provided. It will then get the worksheet from the parameters or prompt the user if none is provided. It will ...

When running multiple jobs we can split an array to work with each separately. Below I have wrote this Powershell function which we can utilize to split array. Lets say you have 20K Mailboxes in your ...

We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell. In a recent series of posts, I explained how to launch a PowerShell script ...

Sometimes you have data in an array data type that needs to be in a string data type. One example of this would be if you need to send the data in an email, you don't want to loop through all of the ...