VB code to run an external batch file using a button in excel

[Krishna.ss]

I have a xyz.bat file in a folder (C:\vsp\excelqn\xyz.bat) & I want to execute the batch file using a button in Excel.
So what should be the code in excel to run that?

 

[AlanSidman]

Look here https://stackoverflow.com/questions/13530371/execute-bat-file-from-excel-vba-macro

 

[Krishna.ss]

This code in the link https://stackoverflow.com/questions/13530371/execute-bat-file-from-excel-vba-macro is not working and the excel file with the button itself it is getting closed. Please help.