By executing the below code, you can run any .bat file in Excel Macro. This is very important that you should keep your Excel Sheet from which you want to execute the Batch file in “C:\” drive only. It can be inside any other sub-folder but in C drive Only.

shell("c:\abc.bat")

'    OR

shell("CMD.EXE /c c:\abc.bat")