How to stop closing Excel in a programmatic GUI?

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.

Answer 1

[Sean de Wolski]

Are you accessing Excel through the COM API?

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

[Khanh]

Hi Sean de Wolski,

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