Appendix e: sample excel/visual basic templates, Getting started terminal connections, Installing acrocomm & excel macro sample – Acroprint AcroComm User Manual

Page 55: Starting the macro, Erminal, Emory, Nformation

Advertising
background image

AcroComm Programming Manual

10. Appendix E: Sample Excel/Visual Basic Templates

10.1. Getting Started Terminal Connections

Setup the Acroprint Terminal communications using the configuration badge, for either
RS232 or RS485 communications, the Clock ID = 1 and the Baud rate = 9600. Connect
the Acroprint Terminal to a standard RS232 or RS485 (converter required) PC serial port
(COMM 1 required for Excel Macro Sample provided). Refer to the Acroprint Terminal
hardware manual for port connection details. This sample macro defaults to COMM
PORT 1, Clock ID 1, 9600 baud. For Modem communications with this sample Macro,
the AcroComm command line needs to be modified with a phone number and
AcroComm.cfg file within the Visual Basic Code. Refer to sample VB code in this
section for location details.

10.2. Installing AcroComm & Excel Macro Sample

A self-extracting zip file SETUP.EXE creates an ACROCOMM subdirectory containing
the following files:

· ACRO.ICO

Acroprint

Icon

· ACROCOMM.EXE

Windows NT/95 Communications program

· ACROCOMM.INI

Acrocomm

setup

file

· ACROCOMM.TXT

Installation

text

· DATALOG.DAT

Temporary data storage

· MCW16.DLL Dynamic

Link

Library

· POLL_CLK.5.3.4.XLS

Excel Sample Macro

· PROGRAM.CLK

Clock

command

list

· README.TXT

Updated

information

· SUPPORT.TXT

Support

Information

10.3. Starting The Macro

To start the sample Excel/Visual Basic Macro, select Poll_clk.5.3.4.xls from the run
window or from Windows Explorer. This Macro will only operate on MS Excel 97 or
later.









55

Advertising