Hi Dick,
I'm glad someone like you cares about my problem.
I sure can post the code, but there are some problems:
1- It fills exactly 32 pages which includes the code for ThisWorkbook, a
userform with a lot of GetActiveWindow and a worksheet.
2- It is filled with comments in french to help the maintenance team and all
the variables names are in french.
3- The application requires many files as input and different templates with
specific characteristics to work.
4- The application is built for french and english users so a lot of code
goes for messages, labels and other things like that.
What I will do is build a simple application that does about the same thing
and test it to see if the problem is always present. Then, I will complete my
post.
Thank you for your concern.
Jac Tremblay
"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