I need to edit the contents of various Excel spreadsheets from VB. The machines will not have
Excel on them so I can't shell it out. I have tried using an ADODC control and populating a
DataGrid. It populates just fine but when you make a change and the data control updates the
spreadsheet you cannot open it anymore. Also if there are two or more records that are identical
the data control cannot handle it and errors out.
Is there any other way to do this?

Kris
Software Engineer
Phoenix,AZ