Using VBA to read/write to ports

[KMJ]

I am new to VBA, but my purpose in using it is that I would like to use it
through Excel to data log information from external sensors and to be able to
manipulate those sensors. I would like to be able to read and write to the
various ports, such as the USB, LAN, Parallel and serial ports. However, I
haven't been able to find a good way to do that through VBA. I was wondering
if someone had example code available of setting it up and being able to do
that. Thank you.

 

[Jean-Guy Marcil]

I am new to VBA, but my purpose in using it is that I would like to use it
through Excel to data log information from external sensors and to be able to
manipulate those sensors. I would like to be able to read and write to the
various ports, such as the USB, LAN, Parallel and serial ports. However, I
haven't been able to find a good way to do that through VBA. I was wondering
if someone had example code available of setting it up and being able to do
that. Thank you.

Why VBA?
VBA is very ill-suited to your purpose.

Use Visual Studio and, more importantly, a real programming language.

 

[Jack]

You can use "sharpdevelop 3.0" tool for dot.net programming. It is
free, small and open source tool.