I'm hoping someone is able to help me as I've pretty much exhausted everything I can find.

I have a set of USB connected "Buzz" PlayStation controllers that I want to be able to read and write to using vba. The controller does not appear in the Device Manager list, however I am able to see the device in USB Device Viewer and I'm also able to read and write to the controller using SimpleHIDWriter, so the computer is able to communicate with the controller - I just need to work out how to do it through vba so I have control over it.

I have been trying to use the modComm module written by David M. Hitchner but with little success. There many variations that I've found that try to list all available devices fail to return any devices for me to connect to. I've also tried modifying the code so that it will take other variations of the Port Name ("Port7", "0x07" etc) but this hasn't worked either. I'm assuming (hoping) I just need to find the correct port name so I can connect to the devices, but I can't work out what it should be.

This is the information returned by USB Device Viewer (if that

[Port7]  :  USB Input Device

Is Port User Connectable:         yes
Is Port Debug Capable:            no
Companion Port Number:            16
Companion Hub Symbolic Link Name: USB#ROOT_HUB30#4&13806df0&0&0#{f18a0e88-c30c-11d0-8815-00a0c906bed8}
Protocols Supported:
 USB 1.1:                         yes
 USB 2.0:                         yes
 USB 3.0:                         no

Device Power State:               PowerDeviceD0

       ---===>Device Information<===---
English product name: "Buzz"

Current Config Value:              0x01  -> Device Bus Speed: Low
Device Address:                    0x07
Open Pipes:                           1

          ===>Device Descriptor<===
bLength:                           0x12
bDescriptorType:                   0x01
bcdUSB:                          0x0100
bDeviceClass:                      0x00  -> This is an Interface Class Defined Device
bDeviceSubClass:                   0x00
bDeviceProtocol:                   0x00
bMaxPacketSize0:                   0x08 = (8) Bytes
idVendor:                        0x054C = Sony Corporation
idProduct:                       0x1000
bcdDevice:                       0x0001
iManufacturer:                     0x01
     English (United States)  "Namtai"
iProduct:                          0x02
     English (United States)  "Buzz"
iSerialNumber:                     0x00
bNumConfigurations:                0x01

          ---===>Open Pipes<===---