Running a batch file from command prompt using VBA

[msalem]

Hi,

I know this can be done but I'm a novice at VBA. I have a batch file AutoLoop.bat which I run from command prompt at the moment. The idea is to run a VBA routine behind the onClick event of a command button in Access which would run this batch file in command prompt automatically. Say if the batch file path is I:\AUTOGEN\LOOPGEN\AutoLoop.bat,
what VBA code can be used.

Thanks for any help.

 

[namliam]

Shell "I:\AUTOGEN\LOOPGEN\AutoLoop.bat"

Lookup the shell function in the help for more details.