.BAT file with Parameter in Excel

[ashlyak]

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