Unable to Open External Program by actxserver

I am getting the following error although the same code works in another device with MATLAB R2021b.

What should I do here?

[Walter Roberson]

Is Microsoft Office installed on the device that is having the problem?

[Rounak Saha Niloy]

Yes, Microsoft Office is installed properly.

[Walter Roberson]

... The 64 bit version?

[Rounak Saha Niloy]

Yes, 64 bit,

Answer 1

[Shanmuganathan]

Hi Rounak,

I understand you are not able to open "Excel" from MATLAB using the function "actxserver".

Please follow the below debugging steps to resolve your issue:

• In order to determine if the issue is with MATLAB or Excel please start Windows Powershell (click start, type 'powershell' and open Windows Powershell app). In power shell, please type this

>>$excel= New-Object -ComObject excel.application

(If this produces an error then the issue is not due to MATLAB.)

• Please try the following commands in MATLAB command window to check whether other office applications are working fine:

>>word = actxserver('Word.Application')

>>p = actxserver('PowerPoint.Application')

• Re-Register the Excel Application: From a command prompt, please navigate to where the Excel.exe file is located and and open Command Prompt in Administrator mode to enter the below command:

>>EXCEL.EXE –REGSERVER

I hope the above information helps resolve your issue.

Regards,

Shanmuganathan