Command prompt help - batch command

[jackvdbuk]

Hello,

im trying to make life easier at work by creating a batch script that needs to start a service on multiple PCs which currently do not have this service running that day.

the problem is the list of affected PCs changes each day and the list is generated in excel.

id like to create a batch script that can be run each morning on these computers.

so far i have the command as : sc \\ PC**** start "serviceXXXX" %1

is it possible to paste the list in the batch file say at the bottom and have a "insert X into that command from below list?"

obviously i need to somehow tell command prompt the PC to check which changes each day but not sure the best method or simplest way (never done batch commands before)

any help would be great

[bytejunkie]

can you do readfiles with a command prompt?

suspect you'd find this simpler in powershell, is that an option?

[jackvdbuk]

bit beyond me that by the looks of the scripting required.

was hoping it to be rather simple but hey ho

- is it possible to replace say x in a cell in excel if there is a number in an adjacent cell perhaps?

[Spreadie]

Can you use a macro to export the list from excel and continually update a file called from the batch command?

We used to do something similar at work, with laboratory sample results.