Does .save work correctly for Excel object in Excel 2010?

Hi, I used to run certain matlab scripts for formatting excel sheets. I use activex for accesing Excel(Office 2003) in those scripts. Now I have migrated to Excel 2010, and now the Excel Object's .save method does not seem to work. can anybody help me?

% Create COM object for the current Sheet.
objExcel=actxserver('excel.application');
objExcelW=objExcel.Workbooks;
ExcelFilePath = pwd;
objExcelF=objExcelW.Open(fullfile(ExcelFilePath, ExcelFileName));
objExcelS=objExcelF.ActiveSheet;

....
some formatting, data write operations etc using the sheet object objExcelS
....

% Delete the COM Object.
objExcelF.Save;
objExcelF.Close;
objExcel.Quit;
objExcel.delete;

The script hangs at objExcelF.Save; :(

[Gnaneswar Nadh satapathi]

use: save('fimename.xlsx',yourvariable) it needs only Excel to be installed in your system. it might be 2003/2010

Answer 1

[Image Analyst]

It works fine for me. Try

objExcel.ActiveWorkbook.Save();

[ES]

Hi Image Analyst, thanks for your reply. When the amount of changes is less, the .save method works. But when the amount of changes made in the Excel after creating the COM is more, the .save runs for eternity. In Excel 2003, .save worked well irrespective of the amount changes in the Excel File. Thanks a lot for your support. Have a good day!