Thread: .BAT file with Parameter in Excel

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

Code:

Dim RetVal
RetVal = Shell("d:\Dir1\Bat1.bat 192.168.1.1", vbMaximizedFocus)

hi!

Thank you!!
One more question, insted of keying in the IP Address, can i make the system to read from a cell ?

- Ashly A K