Dim obj, objs
Dim MACAddress As String
Set objs = GetObject("winmgmts:").ExecQuery("SELECT MACAddress FROM Win32_NetworkAdapter WHERE MACAddress Is Not NULL")

For Each obj In objs
    MACAddress = obj.MACAddress
Next obj