XlsIo- open existing XLSM and SaveAs new file

[Eric Castillo]

I am trying to open an existing XLSM (macro) file, make a small change, then SaveAs a different file. The new file is created and saved but the changes are not reflected, it is like I saved a new copy of the file I opened. What am I doing wrong? I am using full paths, getting no exceptions. It is simply not saving the changes.

FileStream baseInstruction = new FileStream(path, FileMode.Open);

IWorkbook workbook = application.Workbooks.Open(baseInstruction);

IWorksheet worksheet = workbook.Worksheets[0];

worksheet.Range[1, 1].Text = "hello";

FileStream filestream = new FileStream(newPath, FileMode.Create, FileAccess.ReadWrite, FileShare.ReadWrite);

workbook.SaveAs(filestream);

workbook.Close();

excelEngine.Dispose();

[Sridhar Sukumar]

Hi Eric,