Prev: radon transform help
Next: Location of detected image using boundary trace
From: Samuel Foucher on 25 Jul 2010 11:25
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
From: Yair Altman on 25 Jul 2010 12:24
> 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
From: Samuel Foucher on 27 Jul 2010 13:58
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(a)gmailDEL.comDEL> wrote in message <i2hof3$6l2$1(a)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
From: Samuel Foucher on 27 Jul 2010 20:10
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
From: Kat Schuler on 12 Aug 2010 09:37
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!
 | 
Pages: 1
Prev: radon transform help
Next: Location of detected image using boundary trace