Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: Disable Excel Macro
Date: Tue, 6 Jan 2009 11:56:02 +0000 (UTC)
Organization: Atlantic Inertial Systems Ltd
Lines: 28
Message-ID: <gjvgsh$8vp$1@fred.mathworks.com>
References: <gjv9nq$1v8$1@fred.mathworks.com> <gjvata$otq$1@fred.mathworks.com> <907bebc4-6579-4d03-aa25-1188d2fea18f@v15g2000yqn.googlegroups.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-02-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1231242962 9209 172.30.248.37 (6 Jan 2009 11:56:02 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Tue, 6 Jan 2009 11:56:02 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1460496
Xref: news.mathworks.com comp.soft-sys.matlab:509999


Hi,

No I don't.
Actually the full error message is

> In xlsread at 200
  In SpreadsheetAnalyser>pushbutton1_Callback at 147
  In gui_mainfcn at 75
  In SpreadsheetAnalyser at 48
??? File contains unexpected record length.  Try saving as Excel 98.

Error in ==> SpreadsheetAnalyser>pushbutton1_Callback at 147
                [WholeDataFile,txt] = xlsread([Pathname,Filename{1,counter}],'ATP results','A1:U146', 'basic'); %import data and delete unwanted rows and columns

Error in ==> gui_mainfcn at 75
        feval(varargin{:});

Error in ==> SpreadsheetAnalyser at 48
    gui_mainfcn(gui_State, varargin{:});

??? Error while evaluating uicontrol Callback.


I didn't post this bacuase I didn't think it contained useful information. But I could be wrong. If I remove the 'A1:U146', 'basic' from my XLS read statement, then it works, but with the macro problem, Adding the 'A1:U146', 'basic' gives me the error above.

Thanks again

Alex