Problem with prompts while saving and reading from an excel file

Hi,

I have a python script that is reading an excel file every 5 seconds. The excel file needs to be saved for any changes to be read by python. I have a macro running in excel to do this. I have set .EnableEvents and .DisplayAlerts to False however occasional I will be prompted by the save as dialogue in a new instance of excel which has opened alongside my original file with a name something like 1EDA3000

I only get this when I'm running the python script after a about 20mins or so. I guess this is a write and read problem with python reading the file excel is writing to.. ?

Would anyone know how to go about preventing this behaviour..?


Code in standard Module

Please Login or Register  to view this content.

In ThisWorkbook Module;

Please Login or Register  to view this content.

THANKS!