Okay, I was trying to think through every possibility for this code and it hit me what was happening. I was using Timer to pause the function and since this uses the number of seconds since midnight the function was choking as it crossed over midnight. Hopefully this will help anybody else who...
I have a long running vba process (4-8 hours) that will sometimes halt prematurely. Basically, the vba code opens an external process and then waits for that process to change a file. Once that file changes it loops and runs the process again. It has to do this about 5000 times. I will...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.