Excel VBA - Executing external programs in an excel macro

  • Thread starter Thread starter schumacker
  • Start date Start date
S

schumacker

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to execute a command in VBA 2
starting Word with an Excel macro 2
Macro creation via VBA 26
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Running SPSS-Syntax using Excel VBA (Excel 2013) 0
Create executable file to run excel macro 2
Need help on VBA excel macro and API to close an external application 0
Excel VBA Excel 2007 5

Back
Top