exec a *.bat file from a macro

[frotaru]

Is it possible to run a *bat file from a macro ?? if yes how??

For example the bat file name is test01.bat

How can I run this bat file from this sub


Sub mysub01()

Dim FieldOrderChk As String
FieldOrderChk = "=IF(ISERROR(VLOOKUP(R[-1]C,[Fields.xls]PDiff_Fields!R5C1:R50C2,2,FALSE)),"""",VLOOKUP(R[-1]C,[Fields.xls]PDiff_Fields!R5C1:R50C2,2,FALSE))"

If Range("A2").FormulaR1C1 = FieldOrderChk Then
ActiveWorkbook.Save
ActiveWindow.Close
Else
Application.Run "SuppInf.xls!DPDF_Field_Order"
Application.Run "SuppInf.xls!DPDF_Cntrz_End_Chk_Formula1"
End If
ActiveWorkbook.Save
ActiveWindow.Close


!!! Here run / exec test01.bat


End Sub


Thank you

 

[BJungheim]

You should be able to simply add this line:

Shell ("c:\Enter\file\path\here\test01.bat")

 

[frotaru]

hi

Thank you soo much