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
In ThisWorkbook Module;
THANKS!
Bookmarks