[2005] Create excel file

I'm trying to download some information from a database into an excel spreadsheet. Now you'd think this would be easy but I'm having loads of trouble even creating a simple excel file!

I add the Excel 8 reference (Microsoft.Office.Tools.Excel)
When I try to create a workbook (cannot create an application object as there isn't one!?!) it shows this error:

Code:

---

Reference required to assembly 'Microsoft.VisualStudio.Tools.Applications.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' containing the base class 'Microsoft.VisualStudio.Tools.Applications.Runtime.BindableComponent'. Add one to your project.        C:\Documents and Settings\Stephena\My Documents\Visual Studio 2005\Projects\EDMExcelDownload\EDMExcelDownload\Form1.vb        6        26        EDMExcelDownload

---

I've managed to find the required library in the COM list (!?!), as I thought it would be a .NET library.

Would be interested to know if anyone has come across the above error message though?

:afrog: