Using macro to execute a command in Shell Command

**aadarsh** · 10-19-2010, 02:10 PM

Hi All,

I am trying to execute a command using shell script but I am only able to open files but not execute.

I tried the following but none of them work code:

Shell ("cmd /k 'glpsol.exe -m transp.mod'")
shell ("cmd /c start glpsol.exe -m transp.mod) -- it returns an error stating no file exists

Can some one help me,

**MarvinP** · 10-19-2010, 02:24 PM

Hi aadarsh,

As soon as the other program has taken over, Excel code is no longer in control. There are some exceptions to this if the other program is a Micorsoft Office appication and can understand commands comming from Excel.

I've found the best I can do is to use "SendKeys" throught the keyboard buffer using Excel and hope it makes it to the other program.

I hope this helps. Perhaps someone else has a suggestion?

**aadarsh** · 10-19-2010, 02:41 PM

Hey I think i figured out.

the command:

Shell ("cmd.exe /K glpsol.exe -m umbrellas.mod -d LP.dat")

works fine. But it works only when I have the .exe file and other files in the default folder.

Any ideas how I can go to the right folder in the cmd environment using a macro

**MarvinP** · 10-19-2010, 07:06 PM

I was talking with a Microsoft employee a few weeks ago and they were telling me how great the new Windows 7 PowerShell was. It is an upgrade to the old DOS Cmd command. I know very little about it but I wonder if it would allow what you are trying to do.

I'm off to learn more about PowerShell. I was surprised it lived on my computer (windows 7) and I didn't have to download or install it.