Initiate VBA routine from Command-line?

  • Thread starter Thread starter Brad
  • Start date Start date
B

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
 
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
 
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.
 
Thanks
--
Brad


Tom van Stiphout said:
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
Click to expand...
 
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
 
Back
Top