View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ashly A K Ashly A K is offline
external usenet poster
 
Posts: 1
Default .bat file in Excel with parameters

hi!

I am looking for a VBA (or anything!!! yes..i am very desperate) which will
enable me to run a .BAT file with parameters from Excel.

ie: if i have a .BAT file, which will ping a IP Address
..BAT will look like

@Echo off
ping %1

So, when i run from the command prompt, i could run as "filename.bat
192.168.0.10" - which will ping the IP Address.

I want to achieve this thru an Excel File. Ie : there will be IP address
in a Colum, and as users click on that, the system shoud run the .bat file,
by taking the IP address given.

I even tried to call this as a hyper link, but was not able to pass the
parameters.

Could any one PLEASE.... help me ?

-Ashly