Run command in cmd.exe using the string from a particular cell

[smasher007]

So basically guys I have this command string in cell E26 which gets generated by the changing values in the cells E9, E11 & E12.

C:\software license\License.exe Evaluation 30

All I need to do is Run this string which is in cell E26 in cmd.exe using a macro. I cannot figure out how to? I am trying different VBA's but all it doing is opening the cmd and not executing it.

If possible please help me with two different VBA's:
1) Running string in CMD silent mode.
2) Running string in CMD with CMD window open.

__________________________________

Cell Values:-
E9 = File path name
E11 = Evaluation\Annual\Perpetual
E12 = 30\365\730 (Days)

Formula in E26 is:-
=E9&" "&E11&" "&E12

---------- Post added at 10:00 AM ---------- Previous post was at 09:54 AM ----------

Any changes which you would recommend in this?

Please Login or Register  to view this content.

[JosephP]

replace /c with /k if you want the window to remain open

[smasher007]

@ JosephP: Thank you for your reply.

Unfortunately it responds with 'C:\software' is not recognized as an internal or external command, operable program or batch file.

How can I fix this?

[JosephP]

are you sure that the path is correct? can you run that from a command line directly?

[smasher007]

Actually it is not executing the entire path if there is a space in between.

The actual path is 'C:\software license\License.exe'

Any ideas? The thing is my software has many parameters separated by space. eg: License.exe Evaluation 30

However, I am able to execute the entire string from the RUN box (Win + R)

[JosephP]

try

Please Login or Register  to view this content.

[smasher007]

Unfortunately it responds with 'C:\software' is not recognized as an internal or external command, operable program or batch file.

What do the extra """ & """" do?

[JosephP]

they pass the program name in quotes which should avoid exactly that problem!

[smasher007]

OK. Thanks! But it is still stopping before the space.. is there any other alternative.?

[JosephP]

not that I can think of. that code executes as expected in my tests using paths with spaces

[smasher007]

Has the number of "" something to do with the number of spaces? Also is there any other way to paste this in run instead of cmd.exe?

[JosephP]

if you don't want cmd then just use shell

Please Login or Register  to view this content.

the number of quotes has nothing to do with the number of spaces

[smasher007]

if you don't want cmd then just use shell

Please Login or Register  to view this content.

the number of quotes has nothing to do with the number of spaces

The above code returned with a debug window.

But thank you for all your replies. I removed the spaces from the program path and used your first code. The program parameters separated by a space are now working properly.

The only problem now is that the output is now getting saved in "C:\Users\smasher007\Documents". How can I set this to a custom path or to same program directory? Any ideas?

[JosephP]

not really-I guess it's probably a program setting or perhaps it just outputs to the current directory. try changing the current directory to another folder