Create new workbook and new worksheet and close. Worksheet not saved

  • Thread starter Thread starter Patrick
  • Start date Start date
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
 
don't confuse sheet save with workbook save. sheets are part of the workbook
so if wb is your workbook object and ws is a worksheet object
then
set ws = wb.worksheets.add()
will set ws to the worksheet object which has been created in the workbook
so
wb.save true
will save the workbook and thus all sheets. you don't need a ws.saveas
method as well
 
Back
Top