VBA to Insert a Power Pivot Table

When Power Pivot was originally released by Microsoft, it was introduced as a Plug-In to Excel 2010. After the second version of the Plug-In was built and released, the Microsoft Build team moved its focus to writing the product into the 2013 release of MS Office. Unfortunately they ran out of time to write in all the features into the Office 2013 version - consequently there are a number of features that are actually better in Excel 2010 plug in version than the Office 2013 version.