VBA/EXCEL/IP AdDress Change

[dangermouse069]

Hi All...

New Here but need help..

I am trying to find a away of changeing an IP address using VBA..IE

Importing am IP to a Template, but the IP adress needs to be change adding 3 to the End.. ie

10.220.28.33 to 10.220.28.36


Thanks in Advance..

 

[PHV]

Try something like this:
myArr = Split(oldIP, ".")
If UBound(myArr) = 3 Then
myArr(3) = myArr(3) + 3
newIP = Join(myArr, ".")
End If

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[dangermouse069]

Thank You will give it a Go...