Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I execute a command line from Excel 2000 VB ?

Status
Not open for further replies.
Aug 6, 2001
5
0
0
US
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 <> &quot;&quot; then
{Problem Area: I want to execute (&quot;NBTSTAT -A &quot; & c.value & &quot;|find &quot;&quot;MAC&quot;&quot;&quot;) 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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top