K
Kevin Carter
hi
i have wrote the following code that runs a bat file
Dim RetVal
RetVal = Shell("W:\Test\performance\speed.bat", 1)
this works no problem
what i would like to do is have the user enter the file path in a cell and use the cell contents in the code
ie.
Dim RetVal
RetVal = Shell (cell ("C4").value\speed.bat", 1)
what is the correct syntax
thanks
kevin
i have wrote the following code that runs a bat file
Dim RetVal
RetVal = Shell("W:\Test\performance\speed.bat", 1)
this works no problem
what i would like to do is have the user enter the file path in a cell and use the cell contents in the code
ie.
Dim RetVal
RetVal = Shell (cell ("C4").value\speed.bat", 1)
what is the correct syntax
thanks
kevin