USB Communication

[Fan924]

I am looking for some example of using VBA and excel to communicate
with an USB port. USB Item is a ROM emulator card so I am looking for
something similar.

 

[Fan924]

I am looking for some example of using VBA and excel to communicate
with an USB port. USB Item is a ROM emulator card so I am looking for
something similar.

Any USB application would do. I want to see any example on how it is
done with excel vba. TIA

 

[Andrew]

Any USB application would do. I want to see any example on how it is
done with excel vba. TIA

I have some code I used to read a data acquisition card from the
serial port through hyperlink. It required an add in, I believe it
was MS COMMS, or something similar. I had wanted to use it as a real
time data collector/monitor. For that purpose, it did not work very
well. But if I set up a background timer and had the spreadsheet
sample once every 30 seconds or so, it worked well enough. Is this
the kind of thing you are looking for?

 

[Mike S]

Any USB application would do. I want to see any example on how it is
done with excel vba. TIA

These might give you a few ideas:

http://dev.emcelettronica.com/serial-port-communication-excel-vba

http://www.home.agilent.com/agilent...ckey=1474189&nid=-536902639.350794&id=1474189

http://vbacodesamples.blogspot.com/2011/07/usb-device-insertremove-monitoring-with.html

http://www.home.agilent.com/agilent...y=1821503&nid=-536902639.350794.02&id=1821503

http://stackoverflow.com/questions/5723220/excel-how-to-have-multiple-input-devices-usb