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
--
Jac Tremblay