thank you xld
unfortunately I still cannot get it to run. having same error as when I first came accrossit during my searching...

when it gets to this line...
Private Declare Function IcmpCreateFile Lib "icmp.dll" () As Long
there is an error msg bx
Compile error:\
Only comments may appear after End Sub, End Function, or End Property
Again, I think it is me or my versions. (vba ver 6.3, Excel 2003)