I'm running Office 2010 with R2009a, the following command does not work anymore:

 Excel = actxserver('excel.application');

it returns:

??? Error using ==> actxserver at 91
Server creation failed. Invalid ProgID 'excel.application'

I've read somewhere that 'Excel.Application' is upposed to be the registry path for Excel, 

any workaround?

Thanks

> I'm running Office 2010 with R2009a, the following command does not work anymore:
>  Excel = actxserver('excel.application');
> it returns:
> ??? Error using ==> actxserver at 91
> Server creation failed. Invalid ProgID 'excel.application'

same problem as http://www.mathworks.com/matlabcentral/newsreader/view_thread/287715, just in case somebody posts the fix there

Unfortunately I'm still looking for a solution, MS Office 2010 has changed the way we can interact with COM objects. This has significant repercursions in other languages (Perl, PhP, etc.), for instance the following Perl command (the equivalent of actxserver) won't work anymore:

perl -MWin32::OLE -w -e "Win32::OLE->new('Excel.application')"

this will give you the error: 

Win32::OLE(0.1709) error 0x800401f3: "Invalid class string"

These changes are documented here:

http://technet.microsoft.com/en-us/library/cc179076.aspx
http://technet.microsoft.com/en-us/library/ff400328.aspx

I'll keep you posted if I find a solution.

"Yair Altman" <altmanyDEL@gmailDEL.comDEL> wrote in message <i2hof3$6l2$1@fred.mathworks.com>...
> > I'm running Office 2010 with R2009a, the following command does not work anymore:
> >  Excel = actxserver('excel.application');
> > it returns:
> > ??? Error using ==> actxserver at 91
> > Server creation failed. Invalid ProgID 'excel.application'
> 
> same problem as http://www.mathworks.com/matlabcentral/newsreader/view_thread/287715, just in case somebody posts the fix there

It seems to work now, here is what I did:

1. Install MS Office 2010
2- Install MS Office 2007 (trial version), the .exe is available here:
http://lfiles3.brothersoft.com/business/miscellaneous/X12-30263.exe
3. Launch Excel 2010, windows aks me to validate my installation again by entering my product key again.
4. the update screen appears, click custom upgrade.
5. You have the option to keep the old version (2007), choose to upgrade everything except Excel.

I think the effect is to add some important dll in your path and your registry from the previous Excel version.

This is far from an optimal solution but it seems to work so far.

Another issue in case you have Windows 7 64-bits, is to be sure that Office and Matlab are both 32-bits or 64-bits:

http://technet.microsoft.com/en-us/library/ee681792.aspx#BKMK_Disadvantages

Unfortunately the solution with the additional installation of Office 2007 didn't work for me. On the contrary, after I've installed Office 2007 also the importdata(filename.xls) ceased to work properly.

If anyone finds another solution to the problem and posts it here, I would be very grateful! 

"Kat Schuler" <kmschuler@gmail.com> wrote in message <i40tej$8b2$1@fred.mathworks.com>...
> Unfortunately the solution with the additional installation of Office 2007 didn't work for me. On the contrary, after I've installed Office 2007 also the importdata(filename.xls) ceased to work properly.
> 
> If anyone finds another solution to the problem and posts it here, I would be very grateful! 

hey

I think that it's no great help, but I'm using matlab 2010a with microsoft office 2010 (exel and word) and it's working fine. but only with the actxserver function. if I use the actxcontrol function I get the same error message...

actxExcel = actxserver('Excel.Application'); -> runs
actxExcelcontr = actxcontrol('Excel.Application'); -> error

greetings

Just a thought: until this gets fixed, is it possible to have BOTH Office 2003 & 2010 coexist to overcome the problem? Hopefully, the old command would work...
(I have Windows 7 64 bit)

"Samuel Foucher" wrote in message <i2hl0g$25s$1@fred.mathworks.com>...
> I'm running Office 2010 with R2009a, the following command does not work anymore:
> 
>  Excel = actxserver('excel.application');
> 
> it returns:
> 
> ??? Error using ==> actxserver at 91
> Server creation failed. Invalid ProgID 'excel.application'
> 
> I've read somewhere that 'Excel.Application' is upposed to be the registry path for Excel, 
> 
> any workaround?
> 
> Thanks