Create button to run PowerShell scripts, return output to cell

Hi all, I've searched the forum for what I'm trying to do but didn't find anything really relevant. Here's what I'm trying to accomplish:

Every month I manually fill-in an Excel document about key information spread across several servers. This information includes disk space utilization of certain folders, number of antivirus agents installed at a given client location, spam filtering accounts active, etc. Eventually, I want to find a way to gather this information in each section by pressing a button and having Excel execute the necessary commands/queries against these systems. Pursuant to that, I'm starting by trying to create a button that will run a PowerShell script in a given column. I've already built this script (which is designed to run against a remote server) and tested it, I just need to get Excel to run the PS script and return the result to the cell. I know that Excel does this natively via VBscript, and if this isn't possible, can I convert easily from PowerShell to VB?

Thanks much in advance,


Chip

The script outputs the data with correct formatting to the shell. However, the only snag might be that the script, at only one point, is interactive in that it must prompt for a password to be used to execute the PowerShell cmdlet on a remote server. I chose to do this rather than put the password as plain text in the script, and then have to worry about a layer of security on the Excel file. If you or anyone else have alternatives, I'm totally open. Chippy, I'll have to look into your suggestion as I'm not VB savvy.