Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: Disable Excel Macro
Date: Wed, 7 Jan 2009 08:25:05 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 21
Message-ID: <gk1ot1$3t5$1@fred.mathworks.com>
References: <gjv9nq$1v8$1@fred.mathworks.com> <gjvata$otq$1@fred.mathworks.com> <266b8f39-1e44-42bb-b0af-b5de1ac25259@z27g2000prd.googlegroups.com> <gjvtdt$rmv$1@fred.mathworks.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 1231316705 4005 172.30.248.37 (7 Jan 2009 08:25:05 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Wed, 7 Jan 2009 08:25:05 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 869539
Xref: news.mathworks.com comp.soft-sys.matlab:510177


"Alex Thiele" <bert1234@yahoo.com> wrote in message <gjvtdt$rmv$1@fred.mathworks.com>...
> Hi,
> 
> Thanks for the message. Unfortunately even if I set the macro security level to 'very high', these macros still run!
> 
> Regards,
> 
> Alex

Hi

I dont think it is possible then using the built-in xlsread function. But you can probably do it interfacing the activex component directly.

Try looking at this:
http://www.mathworks.com/matlabcentral/fileexchange/22365

You have to look through the documentation for the excel.application object to find out how you can load and disable macros.

http://msdn.microsoft.com/en-us/library/bb978780.aspx

Aslak