Hiya all,

I'm a very new to VB.Net + need some help.

I'm writing a program that has a form and an MS Spreadsheet 11.0 activeX component on it (default name is axMicrosoft.Office.Interop.Owx11.AXSpreadsheet).

I want to be able to import + export data into this sheet.

So far: -

1) I can type data into the sheet in RUNTIME.

2) I can export the data to an Excel file using .Export in RUNTIME.

3) I can import data from a .CSV file, but only at DESIGN TIME using the "Commands and Options"-->Import-->DATATYPE=CSV URL=FILENAME.


Can someone please tell me how to: -

A) Import either a CSV or an Excel file into this component in RUNTIME

B) Export the sheet to a CSV file rather than an Excel file in RUNTIME


Cheers all,
Max

(vb.net 2003 on XP-Home with Office Pro 2000 & 2003)