title: VSTO 3.0 Get/Change an excel 2007 workbook connection
body: <p>I've struggling to find a way to get and change and excel 2007 workbook connection (Menu Data -> Existing Connections -> Connections on this Workbook).It's a connection (several actually) to a SQL Server and used in a pivot table.</p>
  
  <p>I've tried using <strong>Application.ActiveWorkbook.Connections</strong> or <strong>Globals.ThisWorkbook.Connections</strong> but they both return always Null..I've tried in an sheet event as well as in a custom ribbon's button event as well.</p>
  
  <p>The only way left I can think of is use to code a VBA method that does the work and then invoke it in my VSTO code, but it's not very elegant is it...</p>