I was asked to create a database of students using Visual Basic for Applications (VBA) and Excel. It required an input form, print method, and some other features. VBA isn't something I play with every day at work. Nonetheless, each time someone asks me for help and it requires to have some programming skills to accomplish the task - I'm your man to face the deadline. VBA can be extremely helpful when it comes to working with Excel. One should know at least some basics in order to shorten the time they spend on working with data in a spreadsheet. The final result was quite impressive and this isn't my opinion :-) I leave some screenshots below and the whole project free for downloading and mining the code.
Since we've got a few ESXi hosts and over a dozen VMFS(s), it usually takes some time to choose the least overloaded host and datastore. I decided to write the following Powershell script to make...