save data to excel file

[qfchen]

Hi
In order to save data into excel file in my application, I need to define

Dim excelApp As New Excel.Application

but I got error message: "Type Excel.Applicati on" is not defined. What component I might miss? Thanks

[qfchen]

it's resolved by adding a COM module of 'Microsoft Excel'

[harmony123]

I also have thesame declaration but when i've added a reference COM module of excel 5.0 i've got this error..New cannot be used as an interface..pls help

[robjens]

You have Office Interop reference set?