LinkBack URL
About LinkBacks
Hi, experienced Gurus!
How can I communicate with a USB/COM port from within an Excel 2003 macro?
Can I write, send, receive (or whatever) cell contents as text strings using xlVB code?
With appreciation for any help -- George (Zimmer)
Communication between Excel sheet & USB port
Hi, experienced Gurus!
How can I communicate with a USB/COM port from within an Excel 2003 macro?
Can I write, send, receive (or whatever) cell contents as text strings using xlVB code?
With appreciation for any help -- George (Zimmer)
Hello George,
There are no direct ways to communicate with a COM or USB port using VBA. Port communication is very low level programming. That's why there are device drivers. There are 3 options I know of: Write a driver in C, Use the Windows API, or purchase a program to provide an interface to VBA. Click on the link to see an example of how to create a serial interface in VBA using the API. You will probably consider purchasing some software.
Serial Port Communication in Excel (VBA)
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks, Leith.
Your comment (including the reference) was extremely useful for me.
Sincerely -- George
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks