Initiate VBA routine from Command-line?

[Brad]

Is it possible to directly initiate a VBA routine from a Command-Line or is
the only approach to initiate a Macro from the Command-Line which in turn can
initiate a VBA routine. I am trying to understand if there is an alternative
to using a Macro.

Thanks,

Brad

 

[Tom van Stiphout]

On Wed, 26 Aug 2009 19:40:01 -0700, Brad

The available command line switches are documented in the help file
topic "Command-line switches for Access". Perhaps /cmd will support
what you are trying to do.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

What I've done in this circumstance is to use the

/x macroname

command line switch, and have a macro with nothing but a RunCode action.

 

[Brad]

Thanks
--
Brad

On Wed, 26 Aug 2009 19:40:01 -0700, Brad

The available command line switches are documented in the help file
topic "Command-line switches for Access". Perhaps /cmd will support
what you are trying to do.

-Tom.
Microsoft Access MVP

 

[Brad]

John,

Thanks for the help. It looks like there is not a way to directly fire up a
VBA module. Using a Macro is Okay. I just wanted to be sure that I wasn't
missing an easier method.

Brad