Speeding up Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a complex macro that moves a preformatted sheet and brings in a large
amount of data from a database and starts processing it. Based on the data,
it then inserts a line in the form in the appropriate section (items in the
data may not be in order). This inserting and the subsequent actions are very
very slow. Almost to a crawl and working with 300 lines of data to insert
into the sheet pushes the report past the 20 minute mark.

Any general advice to speed this up? All the basic stuff is covered.
Calculation is off, error checking is off, page breaks are off, scren draw is
off. I've optimiazed everything I know. Why does the insert take so long to
do?

Any advice would be great.
 
Hi,

Working with excel object is slower than you use
Variable declaration to store the data,,, or using
txt file is faster ...
 

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

DREAM FEATURE: A macro that moves a row but asks me where to move it 18
calculation 2
Export Macro to new Workbook based on Email Address 7
Mid column sum formulas with varied ranges to sum 17
Run macro from active workbook whose name keeps changing 20
Playing back a Pivot Table macros 2
macro speeds 13
macro to enter data into different line 2

Back
Top