VBA MAC address association to change user accordingly

Copper Contributor

Hello so basically I am trying to have a Status {Department} be managed by using the computer's MAC address not to sure how to explain or if what i have come up with would help

 

example

run getmac
if MAC_Add AA:AA:AA:AA:AA:AA
or
MAC_Add AA-AA-AA-AA-AA-AA

set Department_User to Interior

if MAC_Add BB:BB:BB:BB:BB:BB
or
MAC_Add BB-BB-BB-BB-BB-BB

set Department_User to Recessed

 

thank you in advanced and if there is another way other then VBA I'm open to suggestions thank you

0 Replies