Creating and executing batch file is very useful way for project automation. It is very comprehensive to create complex automation. you can use batch file with excel VBA combination for several operations. Given below are few such examples:
File Download from Servers,
Schedule Macro execution automatically,
Run application at particular time period and so on.
Here is the code which will do same kind of operation,
Dim fNum As Integer Dim rVal As Variant Dim appPath, appfile As String file_Name = "C:\Users\Dreams\Desktop\Test.bat" 'Variable to store Application path which is to be run appPath = "C:\Program Files (x86)\Google\Chrome\Application" 'Variable to Store Application .exe file name appfile = "chrome.exe" fNum = FreeFile 'Create batch file Open file_Name For Output As #fNum Print #fNum, "@echo off" 'Here chr(34) used for double quotes character as output of the string Print #fNum, "cd " & Chr(34) & appPath & Chr(34) Print #fNum, "start " & appfile Print #fNum, "exit" Close #fNum 'Run batch file rVal = Shell(file_Name, vbNormalFocus) ' NOTE THE BATCH FILE WILL RUN, BUT THE CODE WILL CONTINUE TO RUN. If rVal = 0 Then MsgBox "An Error Occured" Close #fNum End End If End Sub