Undefined function or variable 'Sheets'.

Hello! I'm using this code to get formulas from excel sheet:

excel = actxserver('Excel.Application');
excel.DisplayAlerts = false;
ibsex = excel.Workbooks.Open(filename);
pause(5)
ibssheet = ibsex.Sheets.Item('DATA');
line = strcat('B',num2str(today_row+1),':FP',num2str(today_row+1));
formulas = ibssheet.Range(line).Formula;
ibsex.Close
pause(5)
excel.Quit
pause(5)

the problem is that i recive the error "Undefined function or variable 'Sheets'" when Matlab is executing the line:

ibssheet = ibsex.Sheets.Item('DATA');

How Can I fix the problem? many thanks!

[Walter Roberson]

What happens if the Open fails?

[Adriano]

The Open never fails. The Item code fails. Sometimes I recive also this error:

Undefined function 'Item' for input arguments of type 'Interface.000208D7_0000_0000_C000_000000000046'.

[dpb]

I "know nuthink!" about Excel macro language syntax, but is 'DATA' extant or correct argument? Should single be double quotes?

Just throwing out stuff...

[Jan]

Dear dpb, I need some time to understand terms like "know nuthink!"

[Guillaume]

I would recommend commenting out the DisplayAlerts = false in case excel actually shows an alert and instead having

%excel.DisplayAlerts = false; %leave on for debugging
excel.Visible = true;

Does anything pop up in excel?

[Adriano]

Excel doesn't open any pop up but the problem persist.

[Nuttaphon Magteppong]

I have found this problem. Do you have the solution