Communicating with USB devices

[GVF]

I have several Excel add-ins that use MSCOMM32.OCX to communicate with serial ports. I generally use an OnTime event to send a command to the device requesting its current reading and the data is sent along and pasted into Excel.

As more laptops are delivered without serial ports, device manufacturers are moving to communicate through USB ports. The writing is on the wall. I am going to have to retrieve data from a USB port.

The software that is included with the devices is usually inflexible, hence my desire to dump the data directly into Excel where it is easier to manipulate and chart.

Does anyone have a code clip or link to search for VBA code that can call into the USB driver to retrieve data directly from the USB port?

 

[Hypnofrog]

I don't have any USB specific routines, but I did use a USB to RS232 converter successfully to allow two excel programs to communicate successfully using MSCOMM32 over a null modem.

COM1 was the normal serial port and COM3 was the USB to RS232 device.

Rob