Home |
Search |
Today's Posts |
#1
|
|||
|
|||
rs232 with excel
Hi to everybody
I have a question: can I write in a worksheet data that the PC reads using the rs232 port. Are there programs for free? Need I to use Visual Basic, Pascal or Assebly? TY |
#2
|
|||
|
|||
x wrote:
Hi to everybody I have a question: can I write in a worksheet data that the PC reads using the rs232 port. Are there programs for free? Need I to use Visual Basic, Pascal or Assebly? TY --------------------- I don't believe this is an Excel issue. To do what you want would require support of the operating system. If XP supports it, then Excel is happy and doesn't really know anything about what kind of physical network connection you're using. You'll need to convince XP to look across the RS232 as a networking cable to another computer. I suspect that's possible to do, but I haven't touched RS232 in a lot of years. You'd be further ahead to use USB if you could, simply because RS232 is slow by comparison. Good luck.... Bill |
#3
|
|||
|
|||
There are several ways to communicate through the serial port from
within Excel. One way is to write some very complex VBA code that makes OS function calls to open the serial port directly (very complex). Another way is to use a serial communications ActiveX control like the MSComm32.OCX ActiveX control that ships with Visual Studio 6. Another alternative would be to use a 3rd party tool like WinWedge from TAL Technologies. WinWedge is basically an executable program that is designed to run in the background and feed incoming serial data directly to other Windows programs. It also has the ability to send data out a serial port directly from other programs. A tool like WinWedge would probably be the easiest way to do simple serial I/O from within Excel and in some cases you do not even need to do any programming at all. For more information on WinWedge please visit: http://www.taltech.com/products/winwedge.html On Fri, 14 Jan 2005 12:04:45 GMT, "x" wrote: Hi to everybody I have a question: can I write in a worksheet data that the PC reads using the rs232 port. Are there programs for free? Need I to use Visual Basic, Pascal or Assebly? TY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) |