Automating XLConnect actions with VBA

The XLConnect AddIn can be commanded from VBA. This allows for logic to be encapsulated and called by buttons that are in an optimal place for a better user experience.