For anyone else interested, there were two problems, now resolved.
1) Shell wants cmd, not command to open the command window
2) The "Temp" path in my example was really a nest of folders, an
included the "Program Files" folder. But the Shell command used woul
not accept the two-word folder name.
Restructuring the syntax as follows gives a successful result. I
passes two sequential commands, the first a DOS change directory t
open the folder, followed by the executable and the xml file it is t
compile.
x = Shell("cmd /c cd C:\Program Files\Subfolder&&bglcomp.ex
test.xml")
Could also have been done by calling a batch file, but this seem
cleaner
--
jwk
-----------------------------------------------------------------------
jwkz's Profile:
http://www.excelforum.com/member.php...fo&userid=2516
View this thread:
http://www.excelforum.com/showthread.php?threadid=38663