View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default SHELL to open an application and pass parameters to it

You could try...

ID = Shell("command.com /c C:\Temp\bglcomp.exe test.xml")

--
HTH...

Jim Thomlinson


"jwkz" wrote:


I have a compiler that operates on an XML file to create a BGL graphics
file.

At a command prompt, the syntax is [bglcomp.exe test.xml] and the
output would be test.bgl.

Trying to automate this in the macro that creates the XML code, and
with both files in path C:\Temp, I tried:

ID = Shell("C:\Temp\bglcomp.exe test.xml")

This runs with no error messages, but does not compile the XML file.
What is the correct method?


--
jwkz
------------------------------------------------------------------------
jwkz's Profile: http://www.excelforum.com/member.php...o&userid=25167
View this thread: http://www.excelforum.com/showthread...hreadid=386635