what is the best way run converted to VBA macro?

[Valeriya]

Hey,Guys!
Just trying to get a concept and make my Macros run faster.
The conversion itself is very easy, but then I don't have much experience to decide:
1.What is the best way for end user to run converted macro?
-write another macro with openModule?
-what procedure name should I use?
2.Is it really "optimize" the performance?

Thank you in advance for your advise!

Valeriya

 

[lameid]

It may improve performance but I don't know that it does. The other reasons are enough for me...

For those of us who know VBA, it is much easier to read (generally, there is one instance where I use a macro because it is easier to follow).

Also you can put VBA code directly into the click event of a button so that your form is more portable. If you import it to a new database for testing or whatever reason, you don't have to worry about importing dependant objects (macros).

In a pefect world, your useres never see macros. They only see forms and push buttons to run code or macros.

I hope that answeres your question.