How to stop closing Excel in a programmatic GUI?

1 次查看（过去 30 天）

显示更早的评论

Khanh 2014-10-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/158756-how-to-stop-closing-excel-in-a-programmatic-gui

关闭： MATLAB Answer Bot 2021-8-20

Hi,

My programmatic GUI is used to enter data in an excel spread sheet (.xlsx extension).

While users entering data in Excel, data will be compared with statements in my GUI. It will stop users from closing the Excel file until they enter right data.

Is there anyway to do it?

Thanks.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

回答（1 个）

Sean de Wolski 2014-10-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/158756-how-to-stop-closing-excel-in-a-programmatic-gui#answer_155289

Are you accessing Excel through the COM API?

If so, don't close the application unless all of the criteria are met.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Khanh 2014-10-16

Hi Sean de Wolski,

Thanks for your reply. I use winopen(myfilename) to open the file.

此问题已关闭。

Community Treasure Hunt

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

Start Hunting!

Translated by