Execute a macro from VBA code

[nartla]

Hello,

I am working an an app developped in VBA/Access, and I would like to
call a macro (named AutoExec) directly from the VBA code of my
program.

I tried the following :

Call AutoExec

in then VBA code, but when compiling, I get an error saying that "Sub
is not defined".

So what is the correct syntax to call a macro from VBA code ?

Thank you for your help.

[Jens Schilling]

Hi,

So what is the correct syntax to call a macro from VBA code ?

Try : DoCmd.RunMacro (Macroname)

Regards
Jens

[nartla]

On 3 déc, 11:46, "Jens Schilling"
<[e-mail]:

Hi,

So what is the correct syntax to call a macro from VBA code ?

Try : DoCmd.RunMacro (Macroname)

Regards
Jens

Thank you !

DoCmd.RunMacro ("AutoExec")

runs perfectly.

[King Ron]

...also, you should note that anything that you can do in a Macro you
can do using VBA code...you might want to consider rewriting your
Macro functions in code...

One of the plusses of coding in VBA is that you can hide all of your
DBA-like functions from the steenking users so they can't drive your
app into a tree as easily...

Ron, King of Chi...

[lyle]

On Dec 4, 3:24 pm, King Ron <[e-mail]:

..also, you should note that anything that you can do in a Macro you
can do using VBA code...you might want to consider rewriting your
Macro functions in code...

One of the plusses of coding in VBA is that you can hide all of your
DBA-like functions from the steenking users so they can't drive your
app into a tree as easily...

Ron, King of Chi...

I have some users but none of them seems to steenk. (A few smell purty
sweet but in these days of political correctness I pretend not to
notice.) They all seem to want my applications to work properly and
help them accomplish things. What am I doing wrong?

[bobh]

On Dec 3, 5:32 am, nartla <[e-mail]:

Hello,

I am working an an app developped in VBA/Access, and I would like to
call a macro (named AutoExec) directly from the VBA code of my
program.

I tried the following :

Call AutoExec

in then VBA code, but when compiling, I get an error saying that "Sub
is not defined".

So what is the correct syntax to call a macro from VBA code ?

Thank you for your help.

and you also realize that the 'AutoExec' marco gets automatically run
when you run/open your application.
bobh