title: SQL Server Management Objects (SMO) Reference in Excel 2010 VBA Project?
body: <p>Using Excel 2010 using VBA, I would like to be able to start/stop and view running SQL Server jobs, create new tables for import jobs, as well as run backups and other administrative tasks on my local SQL Server.  I would also like to use it as a front end for reports for my imported data.</p>
  
  <p>I am trying to locate a reference to SQL SMO but do not see it in Excel Tools -> References.  It is installed, I have verified that.</p>
  
  <p>My development environment is: </p>
  
  <ul>
  <li>Windows 7 64-bit</li>
  <li>SQL Server 2008 R2 64-bit</li>
  <li>MS Office Premium 2010 32-bit</li>
  </ul>
  
  <p>I am aware that this could be done a dozen other ways but I have been trying to get it to work in Excel for days and searching on this combination of programming has yielded nothing except how to do this with SQL DMO (the former object model) which I do not have installed as its deprecated in SQL Server 2008 I understand.</p>
  
  <p>I also tried a direct reference to the Microsoft.SqlServer.Smo.dll file located at <code>C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies</code> which failed with a <strong>Cant add a reference to the specified file.</strong> error.</p>
  
  <p>Is it possible to gain access to SQL SMO via VBA in Excel or am I out of luck and should move to VB.net / C# etc?</p>