Hello. First post so I appreciate feedback on posting errors...

I believe the problem I'm having is not code-specific but perhaps related to a pc setting. I have an Application.OnTime procedure that runs at 2:45 AM daily. With Excel 2003, XP, IE8 it ran fine. We recently upgraded to Excel 2010, Win 7, IE9. The procedure logs into a website, then loops though 180+ webpages, copying the entirety of each page into an empty copy sheet with No HTMLFormatting, saving the relevant data to a master sheet in a separate workbook, clearing the copy sheet, on to the next webpage.

Now the odd part and the problem. When the procedure runs via Application.OnTime, Excel freezes about halfway through the 180+ webpages (i.e., around the 90th but not always on the same webpage). But, when I run the procedure manually, it runs fine, taking about ~14 minutes to complete. And other Application.OnTime procedures are running fine during the day. So something is happening at 2:45 AM. I've also tried setting the OnTime to run at different times in the early morning hours with the same Excel Not Responding result. It occurred to me today that the only difference between the 2:45 run and the manual run (and other working daily Application.OnTime procedure runs) is that the monitors are on for the latter and off at 2:45 AM, but I can't imagine this being an issue since the 2:45 OnTime does get through half the webpages.

I'm baffled. Any help greatly appreciated.

BDAZ