datagrid of datatable to excell

[RTT]

I'm using windows 2000 with excel 2000 SP3, i import the microsoft office 9.0 object library. But when i user your code i receive the error "System.Runtime.InteropServices.COMException (0x80028018): Old format or invalid type library." at those lines like:
Excel.Workbooks.Add()

also when i use code i find at
http://support.microsoft.com/kb/319180/EN-US/
http://support.microsoft.com/default.aspx?scid=kb;en-us;306022

seems like they al use 10.0 object library, but i only have the 9. isn't theire any simple solution to import my datatable or may datagrid to excel? i think i try almost everything. :s

does anybody has an idea or some code to create an excelfile from a datagrid of datatable....

 

[kulrom]

Hi,
Take a look at this msg it's about the same problem like your

http://www.vbdotnetforums.com/showthread.php?t=3036
There you will find links and explanation how to update the excel library

Cheers

 

[RTT]

found solution to my problem:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/odc_VSTMultCR.asp