Everything HP200LX: Knowledge, Products, Service

9 years, 100's of pages of HP Palmtop Paper, jammed with tips, reviews and how-to's

Most useful, up-to-date Web sites devoted to the HP 200LX

Direct link into 1000's of pieces of Palmtop software

Tips from Our Techs

2008 Catalog
(PDF, 2.6 MB)

Contact Us/About Us

Weekly Palmtop Paper Newsletter
(Palmtop tips, latest happenings, and HP Palmtop Paper Store information)



Privacy Policy

Lotus 1-2-3

Lotus 1-2-3

Automate importing and graphing with an interactive macro

Anytime you want to import text file data into 1-2-3 (importing numbers into 1-2-3 from an ASCII file), and graph your data, you are required to execute a lot of keystrokes for example, (MENU) File, Import, Numbers, enter the name of the file, then enter the commands to graph each time you call up a different file. There is an easier way using macros!

To do this we will create a Lotus template that contains a macro we will use each time we want to view our text file created graphs.

1. In Lotus 1-2-3, press (F5) (GoTo), type AA500, then press (ENTER). This will be a safe place to enter our macro if we delete some rows or some columns in the future, it shouldn't delete our macro.

2. Next give the macro a shortcut key combination by typing \z, then pressing (ENTER) (MENU) Range Name Labels Right (ENTER) (ENTER).

This creates a range name for our macro and makes the hot key combination (ALT) (Z) any time we want to run our macro we need only key in these key strokes.

3. Press (RightArrow) to go to cell AB500 and enter the following lines into cells AB500 through AB502.




Here is an explanation of the lines above:

Line 1: Goes to the Home cell, runs (MENU) File Import Numbers, then waits for you to supply the file name and press (ENTER), then it presses (ENTER) again.

Line 2: Runs (MENU) Range Name Create. Enters the word Graph, presses (ENTER) and waits for you to supply the range for Graph and press (ENTER), then it presses (ENTER) again.

 Line 3: Runs (MENU) Graph Group (using the Graph Columnwise), then runs View to view the graph.

Jesper E. Siig CompuServe ID: [100660,3503]

iPhone Life magazine

Notice about Palmtop.net
The Palmtop Network with its S.U.P.E.R. (Simply Unbeatable Palmtop Essentials Repository) software is now available under the domain name of hp200lx.net.  

We Buy
We buy used palmtops, working or broken: HP 200LX, HP 100LX and 1000CX.

Copyright 2010 Thaddeus Computing Inc