Blocking Alerts Display in Excel COM

2 views (last 30 days)
Piotr
Piotr on 11 Apr 2012
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);

Answers (0)

Community Treasure Hunt

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

Start Hunting!