 |  |  |  |  |  |  |  |
How to read from serial port into excel
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Is there a code in VBA that will read data from a RS232 port and import it into the selected cell in excel or can I buy a program that will work.
Last edited by Hotshottech; Aug 23rd, 2006 at 5:00 pm.
•
•
Join Date: Dec 2004
Posts: 2,413
Reputation: 
Solved Threads: 211
There was a day when I'd say yes. As of right now, we have a few hot threads about this....(not about excel, but about reading from a serial (or parallel) port with V6:
http://www.daniweb.com/techtalkforums/thread52807.html
http://www.daniweb.com/techtalkforums/thread52505.html
http://www.lvr.com/parport.htm#Programming
Basically, it looks as though in XP we have to try to use this new DLL, but it's giving problems to some people. If you can get it to work, it's easy enough to port the data to excel.
http://www.daniweb.com/techtalkforums/thread52807.html
http://www.daniweb.com/techtalkforums/thread52505.html
http://www.lvr.com/parport.htm#Programming
Basically, it looks as though in XP we have to try to use this new DLL, but it's giving problems to some people. If you can get it to work, it's easy enough to port the data to excel.
|
Similar Threads
- Send data on a serial port (C++)
- Serial port communication using C++ (C++)
- any way to communicate with Serial PORT using JavaScript (JSP)
- need help convert c++ to vb6 serial port (Visual Basic 4 / 5 / 6)
- Can read or write to serial port simultaneously (C)
- Read Line from serial port buffer (C)
- Serial Port (C++)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Common Dialog
- Next Thread: How To Connect VB6.0 (Access Database) Using ODBC
Views: 15646 | Replies: 2
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp c++ calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
