User guide

Enterpad VBA for Excel & Word for Windows

Index

Product Overview

The Enterpad VBA saves precious time and prevents errors for those who need to run frequent VBA code (macro/sub). With unique features that allow it to work seamlessly with Excel and Word for Windows, the Enterpad VBA offers a level of reliability not possible with other input devices.

Take your VBA knowledge to a new level and develop the ultimate time-saving solution for your (or your customer's) business. The Enterpad's overlay templates make the integration process easy and the results professional, while providing ease of use to users.

Features

Specifications

System Requirements

Installation

usb.jpgConnect the Enterpad to a free USB port on your computer. If you are using a USB hub, connect the Enterpad to that hub.

Allow the operating system to automatically detect the Enterpad (normally less than 15 seconds). Once detected, a confirmation bubble will appear in the taskbar near the clock. The Enterpad will then be ready to use.

Use the Enterpad with our VBA linker program to connect it to the VBA code of any active applications (Excel & Word). The linker is a portable application, meaning there's no installation process. You just download EP2VBA.zip and unzip its two digitally signed files (EP2VBA.exe and Enterpad.dll) in the same folder.

Running (double clicking) the file 'EP2VBA.exe' will link the Enterpad VBA to any active Excel or Word application. If you want to automatically run 'EP2VBA.exe' when starting your computer, simply put a shortcut to it in the startup folder.

Layout of keys on the Enterpad and macro names

Each key on the Enterpad triggers a corresponding macro name. Thus, key #1 triggers macro "EP_1", key #2 triggers macro "EP_2", and so on. For these to work, an Excel/Word document must be active, the macro name must exist, and the document must not be locked (e.g., when editing).

Key #1 is located at the top left corner and key #120 is at the bottom right corner. The "shift" key on the Enterpad adds 120 to the key numbers. Thus, key #1 becomes key #121, and so on up to #230. This provides a way of triggering 110 additional VBA macros.

Enterpad - Keys position

A macro can be triggered with the key #111, although it is also used as the "shift" key. The macro will be triggered when the key is released, if another key has not been pressed first.

How the linker (EP2VBA.exe) works

VBA macros are executed according to the design of the Enterpad linker EP2VBA.exe. The linker associates each Enterpad control key with a macro name that includes its number (e.g., EP_1, EP_2). The linker is designed to run one macro per use (of the Enterpad) and for Excel to have priority over Word. This means, it will first try with an Excel document, if one is active and a corresponding macro is found. Otherwise, it will try with Word. If no corresponding macro is found, an information message will be displayed.

The following points must be kept in mind: Excel and Word applications can open multiple documents at the same time; only one document will be active per application (usually the last used); if both Excel and Word applications are running, two documents will be active at the same time; an active document will remain active even if its window is not currently focused.

For various reasons, some users (who will recognize themselves) launch a new Excel / Word application for each document they open. In this case, the linker will try to communicate with the active document of the first application launched (Excel or Word).

The linker (and Enterpad) will wait for a macro to finish before launching a new one. If a macro fails (e.g., problem, bug), resetting the VBA editor will allow the Enterpad to resume running requested macros. In the meantime, the Enterpad will continue receiving requests to execute macros (up to 12). Resetting the Enterpad will cancel all pending requests.

The linker was designed to meet the needs of an average user, and it is very easy to modify. We offer custom development services for those who need modifications to the standard paramaters.

Internal operations of the Enterpad

By default, the 10 keys of the bottom row of the Enterpad are used like other keys. This chapter explains how (and why) they can be used to do double-duty.

Shift Key

The shift key on the Enterpad enables the user to trigger 110 more macros ("EP_121" to "EP_230"); Pressing (and holding) the shift key, then pressing the first key (top-left corner) of the Enterpad simultaneously, will trigger the macro "EP_121" (120+1), and so on up to the macro "EP_230".

The shift key is the Enterpad key #111. If you press it then release it before pressing another Enterpad key, it will trigger the macro "EP_111".

enterpad-bottom-shift.jpg

The shift key can also control 9 internal settings/commands of the Enterpad VBA. The following sections explain how.

Adjust audible beep

When used with the shift key, three keys can be used to choose the level of the audible beep.

enterpad-bottom-beep.jpg

The choices are 'HI' for loud, 'MED' for medium and 'LO' for low. The most recent choice will be held in memory until changed, even if the power is turned off.

Load confirmation required

This setting is not relevant for the Enterpad VBA operation.

Its default setting (OFF) means that no confirmation will be required if you would like to transform your Enterpad VBA to a standard Enterpad by way of the Enterpad's configuration software (EPConfig).

To set or unset this option, the keys "OFF" and "ON" in the shift mode must be used. The most recent setting will remain in memory until you change it, even when the power is turned off.

enterpad-bottom-confirmation.jpg

Load confirmation or Factory reset

The 'LOAD' key used with 'SHIFT' is not used for the Enterpad VBA operation.

If the "Load confirmation required" is switched to ON, the Enterpad's configuration software (EPConfig) will wait for this command (this is not a setting) to upload a new configuration in the memory of the Enterpad.

Using this command without the configuration software (EPConfig) linked to the Enterpad VBA will simply freeze it for less than 5 seconds OR reset the Enterpad to its factory settings if you hold the load key up to the time the status light will begin to flash (about 5 seconds).

enterpad-bottom-load.jpg

How to choose one of two layers

The level 1 (default) allows the Enterpad to trigger macros "EP_1" to "EP_230". Selecting level 2 will trigger 230 new macros ("EP_501" to "EP_730").

By pressing one of the two keys, '1' or '2' in the shift mode, the user is able to select which layer will be active. When the second layer is active, the status light of the Enterpad is blinking. The layer 1 will be the default layer when the Enterpad is powered on.

enterpad-bottom-layer.jpg

To empty the Enterpad buffer

The 'ESC' key, when used in the shift mode, allows you to empty the Enterpad internal buffer (i.e, every pressed Enterpad key, waiting to be processed will be cleared).

enterpad-bottom-esc.jpg

 

Tips

In order to ensure optimal use of your Enterpad, the overlay sheet must be correctly lined up with guides on the protective film. The use of a relatively light weight paper will determine the degree of sensitivity needed to activate a key. Pressure should be applied near the center of the key.

Technical Support

If you have any questions, comments, problems or suggestions concerning this product, write to:

Cedeq Industries Inc.
5193 Montee St-Hubert
St-Hubert, Quebec
J3Y 1V8, Canada

Tel: (450) 462-3988
Fax: (450) 462-3988
Web: cedeq.com
E-mail: support@cedeq.com

Notices

The Enterpad™ software copyright

Copyright © 2018 by Cedeq Industries Inc. All rights reserved. The Enterpad software is protected by Canadian copyright laws and by International Agreements.

Limited warranties

Cedeq Industries warrants the Enterpad against defects in material or workmanship for a period of one year from the date of purchase.

If the unit fails to work properly when used under normal conditions, we will repair or replace it free of charge. The defective Enterpad should be returned securely packaged, insured and postage prepaid with a copy of your sales slip to your vendor.

This warranty replaces warranties of any kind either expressed or implied. Cedeq does not warrant, guarantee or make any representations regarding the use of the Enterpad or results obtained, following its use in terms of conformity, accuracy and durability.

Conformity

The Enterpad meets Canadian and American standards (ACNOR 108.8-M1983, code FCC, section 15-1989) with respect to electromagnetic radiation emissions for class A apparatus. Testing was done in conformity with ANSI C6.4-1991 procedure requirements.