Device ID with Excel VBA

Question

I would like to extract the IMEI number/Device ID from the computer using excel.

In CMD I can do it in this way: :netsh mbn sh interface" and from the list given I take the Device ID.

I was tryong to find something online but no luck so far, that's why I'm asking your help, maybe some of you knows where to search or how to start.

How can I do this with excel vba?

score 1 · Accepted Answer · answered Feb 15 '19 at 14:37

1

You can use the following and then use split function to extract what you need

Option Explicit

Public Sub TEST()
   Debug.Print CreateObject("wscript.shell").exec("cmd /V /C netsh mbn show interface").StdOut.ReadAll
End Sub

answered Feb 15 '19 at 14:37

QHarr

score 0 · Answer 2 · answered Feb 18 '19 at 11:32

0

Yes, Thank you. I only had time to try it out today. Thank you once more.

answered Feb 18 '19 at 11:32

K. M.

2 Answers2