How to Programmatically add a QueryTable and Data Connection to Excel

I needed to create an Excel Spreadsheet with a Connection object and link a QueryTable to it.  I could not find a good example of this so I thought I would share.  Please drop me a note if you found this useful! Code listing for sample (Copy Code):         private void createProdSheet(string topicText, bool debugView)        {           …

6