Convert IP address to integer format.
' ------------------------------------------------------------
' Convert IP Address - convert IP Address to integer format
' ------------------------------------------------------------
Function ConvertIP(IPAddress)
Dim IPnumber, IPArray, counter
IPArray = Split(IPAddress,".")
IPNumber = CDbl(0)
For counter = 0 To UBound(IPArray)
IPNumber = IPNumber * 256 + IPArray(counter)
Next
ConvertIP = IPNumber
End Function