Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
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.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - Change IP address on bulk servers using Excel File

Reply
 
Old 04-30-2009   #1 (permalink)
Boris Reuven


 
 

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 SpecsSystem Spec
Reply

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


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46