Modifying a batch file is as simple as editing a text file. Search the forums on how to work with text files.

To run it use this code

Code:
Call Shell(Environ$("COMSPEC") & " /c C:\MyFile.bat", vbNormalFocus)
Note: /c closes the DOS prompt when finished

Hope this helps...