help with DoCmd.RunMacro

[7 of 9]

I am creating a Module in access to export the results of a query to excel and once there run a macro that i have created. the problem is that this is the first time that I have done this and I am not sure how.

when I begin to write the code access tellls me to put it in the following format:

DoCmd.RunMacro (MacroName,[RepeatCount],[RepeatExpressio n])


but when i do ittells me,

compile error expected =

what is the correct syntax

Thanks

[JConsulting]

I am creating a Module in access to export the results of a query to excel and once there run a macro that i have created. the problem is that this is the first time that I have done this and I am not sure how.

when I begin to write the code access tellls me to put it in the following format:

DoCmd.RunMacro (MacroName,[RepeatCount],[RepeatExpressio n])


but when i do ittells me,

compile error expected =

what is the correct syntax

Thanks

IT can be a bit confusing, especially without examples.

doCmd.runMacro "yourmacroname"

that's all you need. The repeat count applies if you want to run the macro more than once and the repeat expression is an option that lets you run just one expression in your macro multiple times. You don't have to include those to run your macro.
J

[7 of 9]

IT can be a bit confusing, especially without examples.

doCmd.runMacro "yourmacroname"

that's all you need. The repeat count applies if you want to run the macro more than once and the repeat expression is an option that lets you run just one expression in your macro multiple times. You don't have to include those to run your macro.
J

It workes! -Thanks J.