Calling Procedure From Command Line?

[Fester Bestertester]

Okay, here's the bonehead question of the day:

Is there some syntax or command line switch that I can use to call a
Public Sub from a command line? If so, what is the syntax?

The purpose: if I can start the Sub from a command line prompt, then I
can make the command a batch file. If I can make the command a batch
file, I can schedule it.

If the sub were, say, basMyProcedureModule.MySubName, could I invoke it
by doing something like this:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /myswitchhere
"C:\MyDataFiles\MyFile.mdb!basMyProcedureModule!My SubName"

[Fester Bestertester]

It goes like this:

You create a macro with a RunCode action that calls the function,
and then you go:

"C:\Program Files\Microsoft Office\Office11\msaccess.exe"
"C:\MyFilePath\MyDatabaseName.mdb" /X MyMacroName

And save it as a .bat

Fester Bestertester wrote:

Okay, here's the bonehead question of the day:

Is there some syntax or command line switch that I can use to call a
Public Sub from a command line? If so, what is the syntax?

The purpose: if I can start the Sub from a command line prompt, then I
can make the command a batch file. If I can make the command a batch
file, I can schedule it.

If the sub were, say, basMyProcedureModule.MySubName, could I invoke it
by doing something like this:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /myswitchhere
"C:\MyDataFiles\MyFile.mdb!basMyProcedureModule!My SubName"