Microsoft Office Spreadsheet 10.0

[Lost User]

Hi, I have a spreadsheet integrated in a windows form, using Microsoft Office Spreadsheet 10.0 component. I would like to know how to save or export it to a new .xls file. Thanks.

[mcljava]

Two choices: Excel Object Model or OLE DB. Depending on what type of dataset manipulation you need to do, that should drive your choice. The Excel Object Model allows closer interaction with Excel whereas OLE DB is more abstract. Search for examples of both and decide what suits your application better.g Mike Luster CTI/IVR/Telephony SME