search

ctakahashi / rest-client

Automatically exported from code.google.com/p/rest-client
Apache License 2.0
0 stars 0 forks source link

How to run the command-line in VBA? #139

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Use Shell function
2. Command line = restclient-cli-2.3.3-jar-with-dependencies.jar -o e:\ 
Request_1.rcq
3. VBA code:
Dim RetVal
Dim CommandLine As String
CommandLine = Worksheets("Sheet1").Range("A2").Value
RetVal = Shell(CommandLine, 1)

What is the expected output? What do you see instead?
The command line can be successfully run in MSDOS Prompt cmd. But in VBA above, 
error prompt that file not found.

What version of the product are you using? On what operating system?
I am using Excel2007 VBA on Windows 7.

Original issue reported on code.google.com by timlam20...@gmail.com on 10 Oct 2011 at 5:21

GoogleCodeExporter commented 8 years ago 
Sorry: closing this issue as it is outside the scope of this project.

Original comment by subwiz on 23 May 2012 at 2:18