Command prompt help - batch command
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 :)
Re: Command prompt help - batch command
can you do readfiles with a command prompt?
suspect you'd find this simpler in powershell, is that an option?
Re: Command prompt help - batch command
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?
Re: Command prompt help - batch command
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.