Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: xlswrite to Excel 2007 problem
Date: Thu, 4 Sep 2008 18:32:03 +0000 (UTC)
Organization: Sandia National Labs
Lines: 15
Message-ID: <g9p9j3$a8b$1@fred.mathworks.com>
References: <g9p4li$7qd$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 1220553123 10507 172.30.248.37 (4 Sep 2008 18:32:03 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Thu, 4 Sep 2008 18:32:03 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1316302
Xref: news.mathworks.com comp.soft-sys.matlab:488640



A little more detail:

I think I can get around the problem if I can get xlswrite 
to invoke Excel 2003 rather than 2007.  To do this I need 
the programmatic identifier (progid) to feed to the command
Excel = actxserver('Excel.Application').  The trouble is 
that, from what I've uncovered is that both Excel 2003 and 
2007 use Excel.Application as their progid.  Does anyone 
happen to know how I can change the progid of Excel 2003 to 
see if that works?  Perhaps I can get 2003 to be invoked if 
I knew what the interface name for Excel 2003 (from Office 
11) is.

Thanks.
M Lenz