Blocking Alerts Display in Excel COM

I solved a problem that blocked me from automation my every day processes.
The reason for blocking was that I have MS Excel 2003 installed on my computer, when trying to open a XLSM file constructed in 2007. I have installed a Converter that enables me to open XLSM files but then a nasty window pops up and stalls the whole process (it awaits to be clicked or Enter to be pressed).
In VBA there is a simple solution to the problem:
Application.DispalyAlerts = False
And its counterparty in matlab script is:
hExcel = actxserver('Excel.Application');
set(hExcel, 'DisplayAlerts', 0);

回答 (0 件)

カテゴリ

ヘルプ センター および File ExchangeUse COM Objects in MATLAB についてさらに検索

質問済み:

2012 年 4 月 11 日

Community Treasure Hunt

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

Start Hunting!

Translated by