Help with Excel and CMD

[Nutkin]

Hi Guys,

You all seem quite knowledgable so I am hoping you can point me in the right direction.

I have an excell sheet with about 600 lines each generates a custom file generation code that can be launched from a cmd prompt in that directory.


Is there any way I can make a script in excell to give me a button that will copy the text from say Q3 and then type it into a command prompt at location C:\Directory\subdirectory

Then move on and loop until it reaches Q647 or a blank cell.

Ive dabbled with either side before but never tried to link the beasts.

 

[Nutkin]

Or even just a page on google would help!

 

[John_w]

What is the actual text in Q3, for example? Is it the name of a program, or parameter to a program, or both?

The Shell function might do what you want, but you need to specify a program to be executed and maybe command line parameters in the first argument:

Shell "C:\Directory\subdirectory\your_program.exe " & Range("Q3").Text, vbNormalFocus

or maybe:

Shell "C:\Program Files\your_program.exe " & "C:\Directory\subdirectory\" & Range("Q3").Text, vbNormalFocus