Don, I will be in touch for your testimony when I approach the IT department
for more funding and an assistant. ;-)

Seriously though, it's certainly a leaky memory problem because on the
advice of a colleague I restarted Windows (why didn't I think of that) and it
worked fine. Not sure how long it'll run for before it fails again (it is
supposed to create 23 reports one after the other) but I guess I should
firstly get out of the habit of hitting standby when I finish for the day.

And you're almost certainly right that it can be simplified. I've been
learning VB as I go along for about 2 years, mostly using this forum and
Google for help, so I have no doubt there are better ways of doing this!

Thanks and kind regards
Tom



"Don Guillett" wrote:

It does sound as if you have created a MONSTER. Excel does NOT like large
external data bases. It sounds like you need professional help to re-design
your project. I'm pretty sure it could be greatly simplified.