hello all,

I am copying a template worksheet in code for a number of base
currencies returned from my datatable. I would like to copy the
template just but have to iterate so i end up copying the previous
sheet. can anyone help me on this. heres the code
thanks
Cyril

int _workSheetIdx = 1;

Excel.Sheets sheets = this.Worksheets;
Excel.Worksheet _wsTemplate =
(Excel.Worksheet)Sheets.get_Item(_workSheetIdx);
_wsTemplate.Name = "Template";

foreach (System.Data.DataTable dtBc in ds.Tables)
{
_wsTemplate.Copy(Type.Missing, _wsTemplate);

_workSheetIdx++;

_wsTemplate =
(Excel.Worksheet)this.Sheets[_workSheetIdx];
_wsTemplate.Name =
dtBc.Rows[0]["BaseCurrencyCode"].ToString();

PopulateCurrentWorkSheet(dtBc, _wsTemplate);
}