Running a Macro in VB

[JAnderson1070]

I have a macro I am trying to run through VB. I use the docmd.runmacro " "
command, but VB is failing to run the macro. Is there something more I need
to do?

 

[Nikos Yannacopoulos]

If you are into VBA already, there's no reason why you would run a macro
from within VBA - it's like using a Ferrari to tow your Yugo
cross-state, when you havre the Ferrari to drive into! Macros are a poor
substitute for code (poor in terms of both possibilities and
performance), and one should get past them the soonest possible.

My suggestion is, convert your macro to VBA code (Access will do it for
you, just select the macro and go Tools > Macro > Convert Macro to
Visual Basic) and run the code itself instead of the macro.

HTH,
Nikos