Hi Dick,
I wander if you got my last comment about the OP. There IS a problem with
the application I wrote and it does not seem to be in the code (not exactly
sure about that, though). When the macro is run the first time, it takes 2
minutes; the other times it is run, it takes some 10 to 15 seconds more each
time. There is no apparent reason for that. Have you tried to do that? Do you
have an idea what the problem could be?

Thank you

"Dick Kusleika" wrote:

Jac

Can you post the code?

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Jac Tremblay wrote:
Hi,
I built an application that fills the sheets of a template with
specific data. So far, all is well. Then, I was asked if it would be
possible to repeat the operation for hundreds or thousands of
workbooks. No problem, I said. I then built another application based
on the first one. It runs very well an does its job perfectly. But
Excel stalls after a specific number of save operations. If the disk
were full, I would understand, but here, there is no reason.
I read all the memory problems on this workgroup and found a lot of
good comments. I tried all I could but things get worse as I modify
the application. It takes a little more time everytime I start the
job, ie, a few seconds. A reboot will not change a thing. It seems
that something is hidden inside Excel's temporary settings or working
environment.
The main loop in the program opens a template, fills some sheets with
filtered data, creates a folder from the contract name and then saves
the Excel workbook in that folder. After 2797 save operations, Excel
stops operating (and the disk is not full).
Can someone help?
Note: I use Excel XP and Windows 2000.
Thanx