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

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.

(also Office 12 = Office 2007, and Office 14 = Office 2010, according to minimal online research http://answers.microsoft.com/en-us/office/forum/office_2010-office_install/office11-office12-and-office14/92a0087e-402c-48e7-a804-026e7ecb0e04?msgId=0e9d6b43-bc44-4033-90b9-7beb1a97e2b4)

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.

[Robert Jones]

Actually, NONE of my matlab calling to excel work with Excel 2013! Still looking for help.

Answer 1

[Image Analyst]

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.

Answer 2

[Kaustubha Govind]

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.