COMxL RS232C is an easy-to-use and very-helpful Add-Ons for MS Excel 97/2000 's user. It lets you link your instrument to your Excel worksheet directly via RS232C port. The readings of your instrument can go/fill-in anywhere you want to them to go by just simply highlighting the range (a defined range). The moving direction of fill-in Data can be selected (top-down or left-to-right)
Key features: * Import instrument's DATA via RS232C port to MS Excel worksheet * Ease to setup for instrument with RS232C port and use. * Date&Time stamping * Send ASCII command to instrument to download its DATA * Timer sampling for DATA input * Pop-up message for Upper/Lower Limits warning
Back top
a). Create a sub directory (C:\COMxL) and unzip COMxL.Zip (extract all files) to the sub directory b). Add-Ons COMxL RS232C in your Excel 1) Run MS Excel 2) From its menu: Tools => Add-ins => Browse. Find and select "COMxL.xla" from the sub directory of COMxL RS232C, click button "OK", then tick it, then click button "OK". 3) In your Excel's menu, you will find "COMxL" => "COMxL RS232C"
Note: COMxL RS232C need VB run-time Libs/OCX files to run it. If you PC does not have them, you have to install them before use COMxL RS232C. You can download the installer COMxLVBLib.Zip from www.gye.homepage.com
Install VB run-time Libs/OCX files: Unzip "COMxLVBLib.Zip" and its three ZipFiles "Disk1.Zip", "Disk2.Zip" and "Disk3.Zip", and extract them in three subdirectories "\Disk1", "\Disk2" and "\Disk3" under a same directory, From "\Disk1", Double click "Setup.exe" to run it. Then follow instructions of screen to finish the installation.
About Communication parameter The Parameter includes two parts One is for RS232C port's settings and other is for in-coming string data format
Example: [GYE01]Com2:9600,N,8,1!XOnXoff(S=+/-,L=9) 1) Part one: [GYE01] - GYE01 is instrument/device name Com2:9600,N,8,1!XOnXoff - RS232C port's settings
2) Part two: (S=+/-,L=9) - Data start with "+" or "-" and its length is 9 charactors Note: Other format in part two: (Range[4 - 12]) means that the Data is charters of from 4 to 12 in the in-coming string
Follow above rule, you can create your own communication parameters based-on your instrument user manual
1). Open your Excel File and highlight the range you want Data to fill in 2). Run "COMxL RS232C" from Excel's menu: COMxL => COMxL RS232C 3). Connect RS232C port by click button "Connect (F1)" in COMxL's Operation Panel 4). Input Data to your Excel File from instrument or download Data by sending a command to instrument
Note: Before you connect RS232C port (Step 3), you maybe need set tools' communication parameters at first time or when you want to change the settings, you also can select the moving direction of Data in your Excel sheet.
Homepage: www.gye.homepage.com Author : Ye Gang Email : gye@homepage.com
OnlineHelp : COMxLHelp.html
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), 2) One of both following has to be known in the string, * The real DATA's starting characters (S) and its length (L), For Example, (S=01A, L=9) * The real DATA's location , for example (Range[4 - 12]) 3) If you want whole string as your DATA, just let the format setting empty, ()
Q2. How to set the Download Command for "Load Data (F5)"? A: Download Command is the instrument's command (Characters) that can be sent from PC via RS232 port to download instrument reading. 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/row for your range 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.
Q4. How to set the settings for timer sampling instrument's DATA? A: The settings is [s!n], "s" means interval in second between samplings, "n" means number of the DATA you want to collecte to your excel worksheet. For example, every 5 second you want to get one DATA from instrument, total DATA are 20, the settings should be [5!20].
COMxL RS232C Registration
Registration fee US $: 59 Registration fee Euro: 0
If you would like to register COMxL RS232C, you can enter the registration online on the Internet at http://shareit1.element5.com/programs.html?productid=131222. Alternatively, you can go to http://www.shareit.com and enter the program number there: 131222. If you do not have access to the Internet, you can register via phone, fax or postal mail. Please print out the following form, and fax or mail it to:
ShareIt! element 5 AG Sachsenring 69 50677 Koeln Germany
Phone: +49-221-2407279 Fax: +49-221-2407278 E-Mail: register@shareit.com
US and Canadian customers may also order by calling 1-800-903-4152. (Orders only please! We cannot provide any technical information about the program.)
US check and cash orders can be sent to our US office at:
ShareIt! Inc. PO Box 844 Greensburg, PA 15601-0844 USA
Tel. 724-850-8186 Fax. 724-850-8187
Registration form for COMxL RS232C
Program No.: 131222
Last name: ___________________________________
First name: ____________________________________
Company: ____________________________________
Street and #: ______________________________________
City, State, postal code: ________________________________
Country: _______________________________________
Phone: _____________________________________
Fax: ________________________________________
E-Mail: ______________________________________
*** Please do not forget to include your e-mail address. *** *** We will use e-mail to communicate with you. ***
How would like to receive the registration key/full version?
e-mail - fax - postal mail
How would you like to pay the registration fee:
credit card - wire transfer - EuroCheque - cash
Credit card information (if applicable)
Credit card: Visa - Eurocard/Mastercard - American Express - Diners Club
Card holder: ________________________________
Card No.: ___________________________________ Expiration Date: ________
Date / Signature: ___________________________
LIMITED WARRANTY
The evaluation ("shareware") version of the COMxL RS232C is provided for evaluation only, on an "as is" basis. The registered version is provided with a 30-day money-back guarantee, provided all materials are returned, and -- in the case of the editor -- no products have been distributed with included COMxL RS232C files. This Excel Add-Ons is intended for use by MS Excel's user, who want to import Data through RS232C port from instrument directly. Users are advised to do so.
TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, GYE SOFTLAB DISCLAIMS ALL WARRANTIES RELATING TO THIS SOFTWARE, WHETHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. NEITHER GYE SOFTLAB SOFTWARE NOR ANYONE ELSE WHO HAS BEEN INVOLVED IN THE CREATION, PRODUCTION, OR DELIVERY OF THIS SOFTWARE SHALL BE LIABLE FOR ANY INDIRECT, CONSEQUENTIAL, OR INCIDENTAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE SUCH SOFTWARE, EVEN IF GYE SOFTLAB HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES OR CLAIMS. IN NO EVENT SHALL GYE SOFTLAB'S LIABILITY FOR ANY DAMAGES EVER EXCEED THE PRICE PAID FOR THE LICENSE TO USE THE SOFTWARE, REGARDLESS OF THE FORM OF THE CLAIM. THE PERSON USING THE SOFTWARE BEARS ALL RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE.
LICENSE TERMS APPLICABLE TO ALL USE OR DISTRIBUTION
The COMxL RS232C and all associated software and documentation are copyrighted products of GYE SoftLab and are protected by United States copyright law and also by international treaty provisions.
All rights not expressly granted here are reserved to GYE SoftLab. The use or distribution of these products is expressly prohibited, except as authorized by the terms of this agreement.
You may not use, copy, rent, lease, sell, modify, decompile, disassemble, otherwise reverse engineer, or transfer the licensed program except as provided in this agreement.
U.S. Government Restricted Rights: Use, duplication, or disclosure by the U.S. Government of the computer software and documentation in this package shall be subject to restrictions as set forth in subdivision (b)(3)(ii) of the Rights in Technical Data and Computer Software clause at 252.227-7013 (DFARS 52.227-7013). Manufacturer is GYE SoftLab, BLK212, Bukit Batok Street 21, #08-251, Singapore 650212.
LICENSE TERMS APPLICABLE TO TRIAL USE OF EVALUATION VERSION
GYE SoftLab grants you a limited license to use this software for evaluation purposes for a period (not to exceed 90 uses).
During this evaluation period, you may make full use of the COMxL RS232C.
If you continue using this software after the evaluation period (90-uses), you MUST make the prescribed registration payment (US$59) to GYE SoftLab through the World Wide Web - your credit card information is sent directly to the credit card processor in a SECURE manner.
LICENSE TERMS APPLICABLE TO USE OF REGISTERED VERSION
The software and the disks on which it is contained are licensed on a non-exclusive basis to you, the purchaser, for your own use. You are not obtaining title to the software or any copyright rights.
You may use the licensed software on a single personal computer system, and make as many copies as needed for backup and archival purposes. If you need to use these products on more than one computer, please contact us concerning site licenses.
LIMITED DISTRIBUTION LICENSE
Permission is granted to individuals charging no fees, and to BBSes, User Groups, Mail-Order Disk Vendors, CD-ROM publishers, and BBS File-Distribution Networks regardless of fees, to distribute the COMxL RS232C, provided they convey a complete and unaltered copy of the shareware version of this product, and provided they claim no ownership of these products.
Permission to distribute these products is not transferable, assignable, saleable, or franchisable. Each vendor wishing to distribute these products must independently satisfy the terms of this limited distribution license.
GYE SoftLab may revoke any permissions granted here, by notifying you in writing.