Get command line from Batch file put it into VBA

[tstc79tt]

i have batch file that run from VBAexcel But the thing is i dont want to run batch file

i want everything on VBA . for example you use vba to cmd and then run this line of command

i have try but i just new to VBA and programing

how can i do it

here the code

this is from batch

@echo off
>summary.txt (
  for %%F in (*chkpackage.log) do findstr /l %1 "%%F" nul||echo %%F:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A
)

and this is code in vba

FileSet = Sheet1.Range("C13")
    txtFpath = Sheet1.Range("C7").Value
    FilePath = txtFpath & "\res.bat"
     
     
     
    ChDrive "C"
    RSP = Shell(Environ$("COMSPEC"), vbNormalFocus)
    Application.Wait Now + TimeValue("00:00:01")
    SendKeys "CD " & txtFpath & "{ENTER}", True
    Application.Wait Now + TimeValue("00:00:01")
    SendKeys "start " & FilePath & " " & FileSet & "{ENTER}", True
    Application.Wait Now + TimeValue("00:00:15")
    SendKeys "exit " & "{ENTER}", True
    Application.Wait Now + TimeValue("00:00:01")
    SendKeys "exit " & "{ENTER}", True

any suggestion i have to admit that i'm really not good in programing if you can add some explaination is a great thing for me to try to study
thank you

 

[tstc79tt]

some one please i'm stuckkkk T^T