Calling batch file from VBA

[dantheram]

This task was driving me insane earlier, here's what i had -

bat file -

copy *.csv all.csv
pause

excel


Dim retValretVal = Shell("filePath")</pre>

now this opened the bat file but ran it on my H:\ directory and not the location of the excel file and the bat file (a folder on my desktop)

what is the correct code?

Thanks

Dan

 

[dantheram]

there should be a rtn in the excel part -

sub bat()
dim retVal
retVal = Shell("filepath")
end sub

 

[dantheram]

any clues?