Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speeding up Macro
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speeding up Macro
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speeding up Macro
If there are worksheet change events then you may want to switch of events.
Alok "jayklmno" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speeding up Macro
Hi,
Working with excel object is slower than you use Variable declaration to store the data,,, or using txt file is faster ... -- Regards, Halim "jayklmno" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Speeding up Macro
Why don't you import everything and then sort?
-- JNW "jayklmno" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speeding Up Macro in VBA | Excel Programming | |||
Help with speeding up vlookup macro | Excel Programming | |||
Speeding up a Data Validation macro | Excel Programming | |||
help with speeding this up... | Excel Programming | |||
speeding up a macro | Excel Programming |