Unable to Open External Program by actxserver

10 views (last 30 days)
I am getting the following error although the same code works in another device with MATLAB R2021b.
What should I do here?
  4 Comments

Sign in to comment.

Answers (1)

Shanmuganathan
Shanmuganathan on 23 Nov 2022
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

Tags

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!