LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default Passing HEX or ASCII to a com port

Hello
I want to create a button in Excel that when I click it, it will send either
and ASCII or HEX command to a COM port to control the on/off function of a
receiving device. So Im thinking the if I put my HEX in cell A1, then the
macro would open the com port, grab whatever is in cell A1 and pass it
through the com port. It will probably need to close the port after the
command has been sent too. I wouldnt mind being able to get a read back
status, but my first thing is to be able to send the command code. I saw a
few forums where someone gave a similar example, but they kept referring to
MSComm through VB. I have not been able to understand how to apply MSComm
after downloading it.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I import data (ASCII) from a com port to Excel ? P Excel Programming 0 March 10th 06 10:03 AM
Capturing Data from a Com Port or Printer Port Newby :) Excel Programming 3 August 19th 05 01:54 PM
Port 119 for NG Jagruti Excel Programming 6 January 24th 05 11:00 PM
COM Port help please Jo Excel Programming 0 November 19th 04 04:11 PM
Com Port and VBA from Excel [email protected] Excel Programming 2 November 5th 03 10:37 PM


All times are GMT +1. The time now is 07:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"