Tuesday, May 27, 2008

Using Excel to manage a Virtual Infrastructure

I have always been a big fan of Excel in terms of using it as a graphical user interface for doing things one should probably not think of at first sight: generate Word documents, as a database interface, generate scripts based on input, etc.

This is exactly what Carter Shanklin has done in this video (and the accompanying script). The idea is simple and the solution elegant. It can be applied to a variety of other tasks that require a lot of similar actions.

Under the hood, a little vbscript is used to launch a powershell script that does the job. You need the VI Toolkit for it to work, of course...

Read more at the source.

No comments:

Custom Search