Excel program hangs overnight
Posted on 2014-11-15
I have a Excel/VBA program that updates items at our Amazon store. Works find, but because it takes so long, I added an auto run feature. I enter the time I wish it to run into a cell, then click a button that calls a Sub that sets the time. Works great. The problem is when I try to run it overnight. It starts run at the exact time it is set to start, but when running it over night, it hangs at some point. Normally it takes 3 hours to the whole process to complete.
Any suggestion for what might be causing it to hang overnight?