Blocking Alerts Display in Excel COM
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (0)
Ver también
Categorías
Más información sobre Use COM Objects in MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!