Re: Memory problem or Excel limitation - For *** Kusleika

From: Jac Tremblay (jac.tremblay_at_donotspam.com)
Date: 03/23/05 

Date: Wed, 23 Mar 2005 09:55:05 -0800

Hi ***,
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

"*** Kusleika" wrote:

> Jac
>
> Can you post the code?
>
> --
> *** 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
>
>
>

Loading