Using COM port with Excel VBA

[payanazo]

Hello,

I have been looking on the net for way to interface a USB COM port with Excel 2013 with VBA.

I have manage to find a solution that actually works.

However there is a problem that I would with it that I cannot understand:

the macro to list connected devices seems to be able to detect up to COM9.

COM10 and above is not listed. Anyone have any ideas why?

Thanks in advance

Dude i totally love you, i have been looking over a week an example like this thanks from the bottom of my heart