P
Patrick
Hi,
I have scenario that users may give a filename and sheetname and both
are
not exiting. So I will create workbook by
Workbook.SaveAs(newWorkbookFullFileName, Missing.Value,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value);
and then the sheet by
Sheet.SaveAs(worksheet.Workbook.Name, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value,
Missing.Value, Missing.Value);
After that, users may close the appliation and I will do:
if (!Workbook.Saved)
{
Workbook.Save();
}
Workbook.Close(true, Missing.Value, Missing.Value);
App.Quit();
But when I use Excel to check the content of the file, the sheet
supposes to
be created as "SheetTest" is not there in the newly created workbook.
Am I
missing anything?
Thanks
Patrick
I have scenario that users may give a filename and sheetname and both
are
not exiting. So I will create workbook by
Workbook.SaveAs(newWorkbookFullFileName, Missing.Value,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value);
and then the sheet by
Sheet.SaveAs(worksheet.Workbook.Name, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value,
Missing.Value, Missing.Value);
After that, users may close the appliation and I will do:
if (!Workbook.Saved)
{
Workbook.Save();
}
Workbook.Close(true, Missing.Value, Missing.Value);
App.Quit();
But when I use Excel to check the content of the file, the sheet
supposes to
be created as "SheetTest" is not there in the newly created workbook.
Am I
missing anything?
Thanks
Patrick