asked on 9/22/2016

Scan IP address, obtain info

I need some VBASCRIPT that will scan an IPv4 address in column A of an Excel Spreadsheet and output the mac-address in column b, the name of the device in column c, and whether it is IPv6 compliant in column D.

Assistance is greatly appreciated

TCP/IP Networking Microsoft Excel VB Script

Last Comment

Dave Baldwin

9/22/2016

Dave Baldwin

9/22/2016

You can only get MAC addresses on your local network segment from devices and computers you are directly connected to. What does 'IPv6 compliant' mean?

Ted Penner

9/22/2016

ASKER

That's a good question. At least we need to know as much about what the device is as possible.

Ted Penner

9/22/2016

ASKER

Whether it could be configured with an IPv6 address perhaps.

ASKER CERTIFIED SOLUTION

Dave Baldwin

9/22/2016

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Dave Baldwin

9/22/2016

Whether it could be configured with an IPv6 address perhaps.

I don't believe the IPv4 address can tell you anything about that.

Ted Penner

9/22/2016

ASKER

Must be able to see source in order to run in our environment.

Dave Baldwin

9/22/2016

I think it is unlikely that Nir Soft will give you the source. It is probably written in C++ and it includes a Code Signing Certificate to verify their identity.