1.

Solve : Using batch file to run Access VBA modules?

Answer»

Is it possible to create a batch file that will automatically start Access (2000) and run VBA code? I have done it with macros in Access, but not VBA code. ThanksYou MIGHT be able to use the /CMD switch. You could pass data as a command line argument provided your code knew what do with the data.

Modules are generally written as event handlers to an UNDERLYING form. Also check out Auto_Open (I THINK that's the correct name) which can be used to kickstart your code.

Hope this helps. 8-)Great. I will give it a try. Thanks for your input.



Discussion

No Comment Found