COM XL RS232C Add-In for Excel

Complete Excel Excel Training Course. Instant Buy/Download, 30 Day Money Back Guarantee

BUY COM XL RS232C

COMxL RS232C: an easy-to-use and helpful Add-On/Add-In of MS Excel 97+. It lets you link your measuring instruments (like Micrometers, Callipers, Temperatures, Balances and Bar-Code scanners...) to your any Excel Worksheet directly via RS232 or COM port.

Link Instruments to Excel Worksheets Directly via RS232 or COM Port

The readings from the instrument can go or fill-in anywhere you want to them by simply highlighting the range. The direction of fill-in Data can be chosen (top-down or left-to-right)

Features:

Link instruments to your ANY Excel Worksheet directly via RS232 port.
Send a command to instruments to download its reading, and timer sampling available.
Import Data to a defined/highlighted/selected range of any Excel worksheet.
Date & Time stamping.
Send ASCII commands (any ASCII characters) from a file / clipboard to the instrument (RS232 device), including wait command (wait few seconds for response from the instrument).
Flexible Data-filter for you to get pure Data you want from the input-strings.
Import Data from text files.
Get Multi-Data from one output-string line of the instrument.
Support multi-instrument linking with Excel Worksheets (one instrument per COM port)

F.A.Q

Q1. What is requirement of input-string format of instrument for this software?

A: 1) The string's last character must be a CR (carriage return) or CRLF(carriage return + line feed) ,
     2) One of both following has to be known in the string,
           * The real DATA Starting characters (S) and its length (L), For Example, (S=01A, L=9)
           * The real DATA location , for example (Range[4 - 12])
   3) If you want a whole string as your DATA, just set the format setting empty "()", or set to "(all)"

Q2. How to set the Download Command for "Load Data (F5)"?

A: Download Command is the instruments command (Characters) that can be sent from PC via RS232 port to download instrument readings. For example, the command string in box is "A +CR +LF", that means the command is Charater "A" + "carriage return(CR)" + "linefeed(LF)".

Q3. How to use Date/Time Stamping with instrument's DATA?

A: To use Date/Time Stamping, You have to select more than one column or row to fill-in the DATA. If the moving direction is "left-to-right", the Date/Time stamping will auto-fill-in at last column in your selected range, if "top down" direction, will auto-fill-in at last row.

Example: Multi data rows is considered as multiple sets of data, but every set of data needs a date/time-stamp (at end of each row)
    Step:
        1) Select a range with x columns (e.g. 3+1=4) and maybe 5 rows (5 sets data) in Excel worksheet
        2) Run COMxL from Excel menu
        3) Set moving direction to "left-to-right", Enable Date/Time Stamp in "CommSettings"
        4) Connect instrument by click "Connect" button

Q4. How to set the settings for timer sampling instrument's DATA?

A: The setting is [s!n], "s" means interval in second between sampling. "n" means the number of the DATA you want collected to your Excel worksheet. For example, every 5 second you want to get DATA from an instrument and total DATA is 20, the settings should be [5!20].

Q5. Possible DDE linking problem. How to solve?

1) Excel not installed properly. You can normally use Excel, but cannot use "DDE" technology linking with COMxL RS232. It might be because some Excel's files were missing or damaging. Re-install Excel is your best bet.
3) OS (Win95/98/NT/2000) not installed properly or Hardware environment (Mother-board) not stable. Re-install your OS is your best bet. Or, install COMxL on another PC to test it

Q6. "Foreign application won't perform DDE method or operation". How to solve?

A: Because COMxL cannot understand some key-words in some Non-English languages (i.e. German, French and Spanish). If you encounter the above error message, use COMxL in English environment (OS: Win95/98/NT/2000 or higher and Excel 97 or higher). COMxL works in Japanese and Chinese environment.

How Does It Work?

What Does It look Like?

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

COM xL RS232C $59.00 Payment Problems/Options

See Also: Excel Add-ins Index & Text Manager Add-in or, All Software

Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS

Watch the latest videos on YouTube.com