Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Disable Excel Macro
Date: Tue, 6 Jan 2009 09:54:02 +0000 (UTC)
Organization: Atlantic Inertial Systems Ltd
Lines: 11
Message-ID: <gjv9nq$1v8$1@fred.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-03-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1231235642 2024 172.30.248.38 (6 Jan 2009 09:54:02 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Tue, 6 Jan 2009 09:54:02 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1460496
Xref: news.mathworks.com comp.soft-sys.matlab:509983


Hi all,

I have a script which interogates hundreds of .XLS files using XLSREAD. However, these XLS files all have macros which display a pop up window if macros are enabled.

This means that I have to sit at the computer closing all the pop up windows as they appear, rather than just being able to set the program off and walk away.

Does anyone know of a way in which I can disable these macros from my MATLAB script, or close the pop up windows as they appear?

Many thanks,

Alex