I am currently using Excel Application Scope (EAS) to make some format changes in excel. The bot is using the “Find and Replace” function in excel.
Normally if you use the same function in excel manually, and after completing the find and replace function it would give you this message.
However, when I run the bot, the Excel Application Scope opens the excel file. After it finds and replaces, the message box does not appear anymore. I have also tried finding something that does not exist in the excel file and replacing it. Excel does not show the message box that the item searched does not exist and the bot continues with its tasks.
Does this happen because Excel Application Scope has a special way of opening the excel file which ignores showing message boxes? If it does is there any way where I can get the message box to show?
Thanks very much.