SpiderManiac
MIS
I hope I'm in the right forum. Here's my approach and problem:
I'm trying to find some MAC addresses on my network. I'd like to make a sub:
For each c in range("a1:a50"
if c <> "" then
{Problem Area: I want to execute ("NBTSTAT -A " & c.value & "|find ""MAC""" from the command line}
and the value it returns, I'd like to put in the cell next to it c.offset(1,0).value = {MAC}
end if
next c
I hope this isn't confusing, I'd REALLY appreciate any and all help anyone can give me.
Thanks,
SpiderManiac
I'm trying to find some MAC addresses on my network. I'd like to make a sub:
For each c in range("a1:a50"
if c <> "" then
{Problem Area: I want to execute ("NBTSTAT -A " & c.value & "|find ""MAC""" from the command line}
and the value it returns, I'd like to put in the cell next to it c.offset(1,0).value = {MAC}
end if
next c
I hope this isn't confusing, I'd REALLY appreciate any and all help anyone can give me.
Thanks,
SpiderManiac