How to use actxserver to open Excel 2010 Application Object? (Both Excel 2003 and 2010 installed)

1 view (last 30 days)
I have Excel 2003 and Excel 2010 installed. Both are 32-bit. MATLAB is R2013a (win64).
When I use actxserver to implement and Excel Application object,I believe that it implements the Excel 2003 Application Object:
>> e = actxserver('Excel.Application')
COM.Excel_Application
>> e.get
.
.
.
Workbooks: [1x1 Interface.Microsoft_Excel_11.0_Object_Library.Workbooks]
.
.
.
LibraryPath: 'C:\Program Files (x86)\Microsoft Office\OFFICE11\LIBRARY'
.
.
.
Path: 'C:\Program Files (x86)\Microsoft Office\OFFICE11'
.
.
.
It seems to reference Office and Excel 11 alot, which (if I'm not mistaken) are Office and Excel 2003.
Would there be a way to use the actxserver command or to change a MATLAB/system setting so that MATLAB could make the distinction between Excel 2003 and Excel 2010?
Thanks in advance.

Answers (2)

Image Analyst
Image Analyst on 18 Sep 2013
I think it just brings up whatever one it thinks is the official installed version. You should probably uninstall the old Offices and re-install the new one. That will probably fix it.

Kaustubha Govind
Kaustubha Govind on 27 Sep 2013
MATLAB just starts up the version that is set up as the COM Automation Server with that Application ID, with the OS. You may want to read Office automation when multiple versions of Office are installed.

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!