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