VBA to open .bat file

Is there a way to use VBA code to open a .bat file?

It is quickly opening and closing the command window but it does not seem to be executing the bat file. When I double click it, it works fine. Any more ideas?

The file path leads onto the m drive. Should I change it to "cmd.exe/m" instead? This doesn't execute it either, but it is opening the command window permanently.

Please Login or Register  to view this content.

The file path leads onto the m drive. Should I change it to "cmd.exe/m" instead? This doesn't execute it either, but it is opening the command window permanently.

Please Login or Register  to view this content.

This is the error that I'm getting from the command line:

'

Please Login or Register  to view this content.

Actually the code needed was much simpler. For some reason this works:

Please Login or Register  to view this content.