So now that we have a sample script to work with, the next step in the process is to see if Excel can pass a parameter to a PowerShell script. For this, I am going to use the same code as before ...

That script simply added 2 to whatever number had been passed to it, and then displayed the result on the screen. If you look at Figure 1, for example ... using nothing but Excel (no PowerShell).

Or you could automate this using PowerShell by converting the file ... First, I need an Excel spreadsheet with some data in it. Fortunately, I was able to download a sample spreadsheet here that has ...