Save data to Excel format

[Alejandro Ochoa]

Hi all,

I have some calculated data from a SQL in VB, kept in a structure, is there a way that I can save that data into an .xls file?.

If someone knows how to do it, can you give me some advice and perhaps some sample code?.

Thanks in advance.

Alejandro.

[SACEIT]

add to your projetc a reference to Excel library
type in
dim myXls as Excel.Application
Put caret over excel.application and press F1