Macro Slowing down Gradualy....

[SpeeD72]

Hi guys.

I´ve wrote an Macro that automaticly creates a chart and
print it to PDF, based on the values of the rows of a
specific sheet. this way i can creta hundreads of charts
per hour.

The problem is that Excell (macro) gradualy SLOWS DOWN
dramatlicly, and after 30 minutes is almost Stoped (with
an output of 1 chart per minute). Why is this? is there a
memory issue that i dont know of? What shloud i do?

Thanks in advance.....
Speed72

 

[Doug Kanter]

I'm not a VBA wiz, but I know enough about programming in general that I'd
wonder if you might have a pile of variables which aren't being released.

Hi guys.

I´ve wrote an Macro that automaticly creates a chart and
print it to PDF, based on the values of the rows of a
specific sheet. this way i can creta hundreads of charts
per hour.

The problem is that Excell (macro) gradualy SLOWS DOWN
dramatlicly, and after 30 minutes is almost Stoped (with
an output of 1 chart per minute). Why is this? is there a
memory issue that i dont know of? What shloud i do?

Thanks in advance.....
Speed72

 

[Frank Kabel]

Hi
one idea: The file size increases if you don't delete the charts
For a more specific answer you may post the relevant part of your code