Hi all, I'm stumped as to why this doesn't work. It works without a hitch on the command line, but when I run this through the shell command in Access, it runs, but doesn't produce the results as in a command line window.
Here's the full command line prompt for the software that I'm shelling to:
C:\Program Files\MSG MCE Software I10>mce.bat -i "/ClassMSystems/QualCode/MCE Output/test.txt" -o "/ClassMSystems/QualCode/MCE Output/testout.txt"
Here's the VBA code:
Shell "C:\Program Files\MSG MCE Software I10\mce.bat -i ""/ClassMSystems/QualCode/MCE Output/test.txt"" -o ""/ClassMSystems/QualCode/MCE Output/testout.txt""", vbHide
in general there is a .bat file called that takes an input file (the path/name following the -i) and puts out an output file (the path/filename following the -o)
I'm using the double quotes because my folder names have spaces. I'm lost.
It runs without errors, but the output file is not created. If I copy and paste the code to a command window and remove the double quotes it works fine.
Is there any way to stop or capture the output of a call with Shell? That might help me solve this.
Any ideas would be great appreciated.