These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 11, 2014

RVTools Combine Multiple

Executive Summary

For my current internship we work with a lot of different virtualization technologies. There is a pretty standard tool that many companies use to inventory their VMware environments called RVTools[1]. We receive many of these reports from clients and needed a way to combine all of these reports into one excel sheet.

Much of the work previously has been done manually which involved copy each excel sheet that contains over 20 tabs into one excel sheet. This would take consultants a couple of hours to complete so they could perform additional analysis without having to look at multiple workbooks.

The other task that had to be done is the mapping clusters with their respective hosts across all vCenters and vSpheres. The diagram provided shows a basic sample configuration. This information becomes very important in terms of software asset management and licensing of these assets. There can be potential licensing implications with virtualized servers running in a high availability cluster with distributed resource scheduling.  In which most cases specific information on each cluster and their hosts that the virtual machines are running on become relevant in managing these assets.

This is where my VBA macro comes in. My macro can take multiple reports and combine them into one consolidated excel sheet. It will also provide a summary sheet with the list of clusters and the hosts that are a part of each clusters on the same line. The summary tab will also show if High Availability is turned on along with the number of vMotion events that have taken place on that cluster.


  • Write Up: RVTools Combine Multiple
  • Note: Because of the sensitive information of the VBA project the code has been omitted from the post and has been submitted to the TA via Learning Suite. 


Blog Archive