Using VBA to read/write to ports KMJ 12/9/2008 10:10:02 PM 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.

RE: Using VBA to read/write to ports Jean-Guy Marcil 12/9/2008 11:19:03 PM "KMJ" wrote: [Quoted Text] > 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.

Re: Using VBA to read/write to ports Jack <pjpspeed[ at ]gmail.com> 12/10/2008 9:44:13 AM You can use "sharpdevelop 3.0" tool for dot.net programming. It is free, small and open source tool. On Dec 10, 4:19 am, Jean-Guy Marcil <JeanGuyMar...[ at ]discussions.microsoft.com> wrote: [Quoted Text] > "KMJ" wrote: > > 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.