Results 1 to 2 of 2

Thread: [2005] Create excel file

  1. #1

    Thread Starter
    Fanatic Member Valleysboy1978's Avatar
    Join Date
    Nov 2004
    Location
    Planet Xeoroaniar CC Posts:1,928,453,459,361
    Posts
    770

    [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
    Life is one big rock tune

  2. #2

    Thread Starter
    Fanatic Member Valleysboy1978's Avatar
    Join Date
    Nov 2004
    Location
    Planet Xeoroaniar CC Posts:1,928,453,459,361
    Posts
    770

    Re: [2005] Create excel file

    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?

    Life is one big rock tune

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width