P
Hello, I'm trying to make a simple HMI using Excel/VBA and an ActiveX driver for PLC communications. Basic functionality for the PLC part is OK (reading and displaying PLC registers in worksheet cells and sampling periodically with the ontime function).
However, as soon as I begin programming macros with more elaborate functions such as charts, moving data from one sheet to another, removing/adding rows, etc., a lot of temporary files are created and left behind in the Windows temp directory (files such as msoXXX.TMP and some other extensions). As far as I know, Excel creates temp files only as needed and should be able to clean them all up when it is closed, and not keep adding and adding temp files while it is running.
After a few hours or days, operation may become slow and erratic and the application needs to started up again, removing manually the temp files.
Could anybody shed a light into this subject? I'm using windows 98 and Excel 2000. I tried to strip down the application to detect which functions leave behind the temp files, but even the most basic ones seem to have that problem (simply adding a row programatically and filling it with data can generate temporary files which aren't deleted when Excel closes)
Pat
However, as soon as I begin programming macros with more elaborate functions such as charts, moving data from one sheet to another, removing/adding rows, etc., a lot of temporary files are created and left behind in the Windows temp directory (files such as msoXXX.TMP and some other extensions). As far as I know, Excel creates temp files only as needed and should be able to clean them all up when it is closed, and not keep adding and adding temp files while it is running.
After a few hours or days, operation may become slow and erratic and the application needs to started up again, removing manually the temp files.
Could anybody shed a light into this subject? I'm using windows 98 and Excel 2000. I tried to strip down the application to detect which functions leave behind the temp files, but even the most basic ones seem to have that problem (simply adding a row programatically and filling it with data can generate temporary files which aren't deleted when Excel closes)
Pat