converting macros to modules

[lscheer]

I'm sure someone has some thoughts/commentary on the usefullness of converting macros to modules.

I've created my database to do some complicated tasks using macros as my VB skills are too limited to be writing full-scale modules (basically anything beyond simple command buttons and similar events).

So I'm trying to enhance the performance of my database, and I was wondering if it would be beneficial to convert all the macros to modules, or if it matters enough to worry about it...

Thanks!

 

[FoFa]

I have not typically found a compelling reason to convert a macro to a module just to do it. If you had a very large macro (I never have had one that large) there maybe a compelling reason from a performance standpoint since the module level is compiled. I like macros for the sake of keeping things simple. Complex code I will put in a module, or code that will not work in a macro (feeding form fields as a parameter, or using a variable value), but "if it aint broke, don't fix it".