Macro taking longer each time

  • Thread starter Thread starter KobusD
  • Start date Start date
K

KobusD

I have asked in the WORD ng, but no received no replies, so I'm hoping
that someone here can help....

I have a VBA program that imports information from Excel into Word
and
produces a report. The program is taking longer and longer, but the
data being imported is the same volume. The Excel sheets, Rows &
Columns are "converted" into class objects.

Is there some kind of cache-ing that would take place under this
arrangement which would cause the slow down?

Any other possible areas I should explore?
 
Hard to guess without seeing the code. Are you sure that all objects are
getting freed? Sounds like you are either using more memory or some array
isn't getting cleared and continues to grow.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rerunning Macro takes longer after each consecutive use....Why? 9
Macro speed decreesing after each run 6
Macro taking longer every run 2
Excel 2007 macro recording feature no longer works for inserting p 4
macros in ribbon no longer work 1
display message box in excel(2003) using VBA word(2003) 0
processing time (revised and re-posted) 10
Saving takes soooo long 2

Back
Top