hi:

purpose: clone the firest sheet in Excel.xls into excel2.xls

here is my code
it well done in winform£º
-------------------------------
string SubFile=@"D:\Excel2.xls";
  string MainFile=@"D:\Excel.xls";
  Excel.Application ExcelMainFileApp,ExcelSubFileApp;
  Excel._Workbook ExcelMainFileWorkbook,ExcelSubFileWorkbook;
  Excel._Worksheet ExcelMainFileWorksheet,ExcelSubFileWorksheet;
  try
  {
   ExcelMainFileApp = new Excel.Application();

//open source
ExcelMainFileWorkbook=ExcelMainFileApp.Workbooks.Open(MainFile,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missin
g,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Miss
ing,Type.Missing);

ExcelMainFileWorksheet=(Excel._Worksheet)ExcelMainFileWorkbook.ActiveSheet;
   string name=ExcelMainFileWorksheet.Name;
   ExcelMainFileWorksheet.Cells.Copy(Type.Missing);

   ExcelSubFileApp = new Excel.Application();

//destination
ExcelSubFileWorkbook=ExcelSubFileApp.Workbooks.Open(SubFile,Type.Missing,Typ
e.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,T
ype.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing
,Type.Missing);
ExcelSubFileWorksheet=(Excel._Worksheet)ExcelSubFileWorkbook.Sheets.Add(Exce
lSubFileWorkbook.Sheets[ExcelSubFileWorkbook.Sheets.Count],Type.Missing,Type
.Missing,Type.Missing);
ExcelSubFileWorksheet.Paste(Type.Missing,Type.Missing);//failed in webform
,when in winform it's ok
   foreach (Excel.Workbook book in ExcelSubFileApp.Workbooks)
   {
    book.Save();
   }
   ExcelMainFileApp.Workbooks.Close();
   ExcelSubFileApp.Workbooks.Close();
   ExcelMainFileApp.Quit();
   ExcelSubFileApp.Quit();
  }
  catch( Exception theException )
  {
   }
  finally
  {

  }
-------------------------------
but when in webform ,it's failed in   "
ExcelSubFileWorksheet.Paste(Type.Missing,Type.Missing); "

i have configed the DCOM right about excel .
(run dcomcnfg.exe and config Microsoft Excel Application.)
but it's still fail :(    (without config it failed in  "ExcelMainFileApp =
new Excel.Application();")

anybody knows why?