Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
run external programs Stephen Miller Excel Discussion (Misc queries) 1 May 24th 10 09:40 PM
Copying Excel 2007 data to external programs Cindy Excel Discussion (Misc queries) 3 October 27th 08 04:57 PM
Column Selection using external programs olitong Excel Discussion (Misc queries) 0 December 21st 05 06:08 PM
opening different programs with excel macro buttons shrek Excel Worksheet Functions 0 September 30th 05 12:41 PM
Running external programs Alan Beban[_4_] Excel Programming 4 December 20th 03 04:06 PM


All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"