Need excel to execute a script as a macro to open a folder on a network computer

[ace2go]

I need excel to execute the following .bat file, except fill in corresponding ip address information that is located in cells B8-B66.

@ECHO OFF
ECHO.
ECHO *************************************************
ECHO ** This Batch file allows you to connect to a c$
ECHO ** of another Computer
ECHO *************************************************
ECHO.
SET /P IP=[Please Enter the IP Address of the Host:]
ECHO.
SET /P NAME=[Please Enter your Account Name:]
ECHO.
ECHO.
NET.EXE USE \\%IP%\IPC$ /USER:pc\%NAME% /PERSISTENT:NO
START /WAIT \\%IP%\C$
NET.EXE USE \\%IP%\IPC$ /DELETE

End result will be - you click on a button in excel next to the ip of the computer you want to look at, and it will execute the bat which will open the corresponding C$ drive of that IP, asking for the username and password

[ryno du preez]

Hi
Do you want the bat file to read the IP from the excel sheet ?