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.