Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Executing external programs in an excel macro
Hi everyone:
I want to execute a dos cmd program from an excel macro. Which is the way to do this?? Is there ary "ExecProgram" method in VB?? Example: 1. I want to execute the "ping" command from my excel macro. 2. The parameters for the ping command are the ip destination address (abc.def.ghi.jkl). If anyone knows how to do this, i will be very thankful. Schumacker |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Executing external programs in an excel macro
Hi Schumacker,
You could shell the command, for example RetVal = Shell("PING ""Yahoo.com""", 1) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "schumacker" wrote in message m... Hi everyone: I want to execute a dos cmd program from an excel macro. Which is the way to do this?? Is there ary "ExecProgram" method in VB?? Example: 1. I want to execute the "ping" command from my excel macro. 2. The parameters for the ping command are the ip destination address (abc.def.ghi.jkl). If anyone knows how to do this, i will be very thankful. Schumacker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run external programs | Excel Discussion (Misc queries) | |||
Copying Excel 2007 data to external programs | Excel Discussion (Misc queries) | |||
Column Selection using external programs | Excel Discussion (Misc queries) | |||
opening different programs with excel macro buttons | Excel Worksheet Functions | |||
Running external programs | Excel Programming |