Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code hangs Excel ... Why? ... and how can i debug??
I have written an Excel a VBA module that batch pulls HTML pages into excel (thus converting them to spreadsheats). I then extract certain cells and save them to a table in a master workbook, I then close origional html and repeat the process. So long as the batch size is small it runs fine. But If I attempt to process to many pages Excel hangs. Leaving no clue as to why and Excel's CPU usage is 0%. At first I just thought that it was just "processing" some code and if I waited it should be fine. each batch loop only takes 1 to 2 minutes. How can I pinpoint when, where and why the code fails. Thanks, Simon. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code hangs Excel ... Why? ... and how can i debug??
What happens if you hit Esc while excel is "hanging" ? Do you have to
force-quit excel to recover? You could try adding debug statements or writing out progress to a log file or worksheet as the batch runs. Ie. all the ususal approaches. Tim "Simon May" wrote in message ... I have written an Excel a VBA module that batch pulls HTML pages into excel (thus converting them to spreadsheats). I then extract certain cells and save them to a table in a master workbook, I then close origional html and repeat the process. So long as the batch size is small it runs fine. But If I attempt to process to many pages Excel hangs. Leaving no clue as to why and Excel's CPU usage is 0%. At first I just thought that it was just "processing" some code and if I waited it should be fine. each batch loop only takes 1 to 2 minutes. How can I pinpoint when, where and why the code fails. Thanks, Simon. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
debug code | Excel Discussion (Misc queries) | |||
Debug Error in Code | Excel Discussion (Misc queries) | |||
Excel hangs up. | Excel Discussion (Misc queries) | |||
Excel Hangs | Excel Discussion (Misc queries) | |||
How to debug a VB dll used in Excel | Excel Programming |