Francesco -
I've recently completed a very simple Windows form application to
automate data loading with C# and Excel {open XLS, change date, update
XLS, save, load data into SQL Server, repeat}.
Here are the important Excel related statements assuming you've got the
PIA off of MSDN, installed and registered it (all part of the
directions).
object optional = Missing.Value;
object updateLinks = 0;
Microsoft.Office.Interop.Excel._Workbook wkb = app.Workbooks.Open
(fullname, updateLinks, optional, optional, optional, optional,
optional, optional, optional, optional, optional, optional, optional,
optional, optional);
Microsoft.Office.Interop.Excel._Worksheet wks =
(_Worksheet)wkb.Worksheets.get_Item(MySheet.Text);
wks.Activate();
wks.Visible = XlSheetVisibility.xlSheetVisible;
Range wksRange;
wksRange = wks.get_Range("H7", "H7");
wksRange.set_Value(Missing.Value, workingDate);
app.Calculate();
wkb.Save();
wkb.Close(false,Missing.Value,false);
app.Quit();
If this is too cryptic, drop me an email and I'll provide more detail.
Terry