Hi Modi,
Pls find the UDF for retreiving IP Address of your machine.
link
http://stackoverflow.com/questions/828496/how-to-retrieve-this-computers-ip-address
Function GetIPAddress()
Const strComputer As String = "." ' Computer name. Dot means local computer
Dim objWMIService, IPConfigSet, IPC
On 7/1/11, L.K. Modi wrote:
> Dear Group Members
>
>
> I need an excel file in wihch by running macro we can see our IP ADDRESS.
> Please provide me that file by which we can know the IP address of our
> System
>
>
> Regards
> LKModi
>
> --
> ---
