Code Speed

[Flavoursavor]

Hello Everyone,

This may be a pretty simple answer, but I figured I would ask the experts.

I have 7 modulethat each perform an ODBC query on an AS400 database, then return and perform a regex to delete the unnecessary code.

Each of the macros places the data on a seperate sheet, and then I have another module that works through each sheet and formats. ie headers and the such.

My question is, would my code work faster if i had it all within one module, and call each of the subroutines, or to leave it within seperate modules.

Will i achieve any performance enhancements either way?

Thanks

 

[BrianB]

IMHO your suggestion would not improve perfomance.

Try turning off calculation and screenupdating first. This usually makes a dramatic difference.

The ODBC query might be a main problem due to variance in server usage/speed. Could try running when everyone has gone home.

 

[Flavoursavor]

Hi Brian,

Thanks for the advice.

I ended up changing the way that the query performs by keeping an open ODBC connection and looping through each of the queries, then going back and performing all of the formatting.

Thanks again!