Macro Object 3

[stephenj789]

I have a macro that I created using the Macro Builder in Access. I would like to run that macro in a VBA module. How do I refer to the macro in the VBA code and get it to run? Thank you.

 

[KyleS]

Docmd.RunMacro "MacroNameHere"

Kyle

 

[p27br]

or you can use the wizard to convert the macro to VBA

Tools > Macros > Convert macros to visual basic

 

[stephenj789]

The first one worked and I am sure the second suggestion would work to. Thanks!

 

[KyleS]

Happy to help :

Kyle

 

[p27br]

If you plan on learning VBA, which will give you so much more possibilities than macros, then converting your macros to VBA is a good way to start - see how they 'translate' to code.

thanks for the star