![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | Change IP address on bulk servers using Excel File Hello guys, I have this issue that I need to change NIC info on 100 servers. I would like to use a VBS. I have XLS / CSV file that conatins the following: 1. Server Name 2. IP Address 3. Subnet Mask 4. Default Gateway 5. Primary DNS 6. Secondary DNS I need the VBS query the info from the cells and distribute the command to all servers. Example: Column A = Server Name Column B = IP Address Column C = S.MASK Column D = DG Column E = 1st SM Column F = 2nd SM A1;B1;C1;D1;E1;F1 srv1;192.168.2.134;255.255.255.0;192.168.2.1;192.168.2.2;192.168.2.3 .. .. .. .. srv100.................................................................................... so I have some algorithm that I think should be (hope that have no mistake on my mind): Column A = Server Name Column B = IP Address Column C = S.MASK Column D = DG Column E = 1st SM Column F = 2nd SM 1. open excel file 2. query column A1 3. query column B1 4. query column c1 5. query column d1 7. query column e1 8. query column f1 9. set IP address, SM and DG on a server that was on A1 10. Loop until no data on cells (a2. .....aX) I would be very thankfull. Boris Reuven -- Boris Reuven System Administrator. MCSA: Messaging 2003, MCTS, MCP, CCA - Citrix Certified Administrator: PS 4.5 + XenApp 5.0 |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Address of incoming & outgoing servers for Windows Mail | Vista mail | |||
| Help needed to change file permissions (bulk) | Vista General | |||
| Using Powershell to change the group names in bulk | PowerShell | |||
| How To Get Excel File Folder to Associate with Excel File Open | Vista file management | |||
| Vista ASP.NET 2.0 Cannot open Excel File using Microsoft.Excel 12.0 COM object | Microsoft Office | |||