Can you execute a DOS command from an Excel Macro?

Can you execute a DOS command from an Excel Macro?

[Ivan F Moala]

On 2002-03-10 20:16, Anonymous wrote:
Can you execute a DOS command from an Excel Macro?

Yes you can, however most com commands
can be done in VBA.
What are you trying to do ??

Have a look 1st at the shell command


Ivan

I want to run another application ie have a shortcut to it in the spreadsheet or a button with a macro assigned to it that will run the program. This is the command line as I would to run it form the DOS prompt:
"C:Program FilesTTERMPROttpmacro.exe" "C:Program FilesTTERMPROlogin.ttl"

Thanks.

[Mark O'Brien]

How about creating a batch file (*.bat) and running that using "shell"?

Yep,
That will work.
Thanks Heaps.

[brettvba]

using a bat file is easy enough but what if you don't want to tag a batch file along with the spreadsheet can you not write specific code e.g. c:runme.exe

[Mark O'Brien]

You can create a batch file using VBA though using "Open", "Write #" etc. You just create the file in a temp directory and delete it on exiting Excel to tidy up. In this case it would only take about 5 lines of code and negligible execution time.

Thanks all for your help.
With your help I have found that I can do what I wanted as follows:
=====
Sub GatherData ()
Dim ReturnValue
ReturnValue = Shell("""C:Program FilesTTERMPROttpmacro.exe"" ""G:iDO Messagingttermpromacrosbdf.ttl""", 1)
AppActivate ReturnValue
End Sub
======
The trick was to get the "" right.

Thanks Again!