Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ExcelVBA Comport coms

tredla123

Systems Engineer
Nov 14, 2024
1
My home auto system has now died.


The server it runs on is 16 years old and has now become unstable. It dies every few hours.


The software, called Touchsoft, only runs on Windows XP and the original deveplopers do not exist anymore/died.


What I have is:


All the wireless switches that are hard-wired to all the devices in the house and operates on the 868 MHz band.


A USB dongle attached to the dysfuntional server on Com port 3 that interprets the data signal from Touchsoft and activates the wireless switches.


A "touch screen" monitor that can plug into any Windows PC. The buttons in Touchsoft are shown on the touchscreen and are activated by touch.


What I have done so far is:


Wrote an Excel VBA front-end with buttons for every device and which shows the state of every button ie ON or OFF.


The Button press ON or OFF can poduce the necessary string/data if I know what format it must be.


What I cannot do yet is:


How to send the string/data to the selected Com port eg Com3.


What the format of the string/data must be in.
 

Similar threads

Part and Inventory Search

Sponsor

Back
Top