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
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