tanya@adds.newyork.NCR.COM (Tanya Katz) (11/28/88)
ATTN NETLANDERS USING LOTUS 1-2-3:
I have a question about generating a macro using Lotus so
that data entry can be accomplished without pressing the <Return>
or <Enter> key.
Here are the specifics of my requirement:
The data required is alpha (six letters total) broken down into
the following fields:
COLUMNS: B C D
2 letters 3 letters 1 letter
AA LAX Y
BA SFO F
UA SAN C
...
We would like to be able to continuously enter the
alpha data and have the cursor move from column D back to B
in "raw" mode, ie. without pressing the return key after the
row is filled.
If anyone can help me, I would appreciate response
via email. I am posting this for a friend who doesn't have
access to the new-net and I would like to be able to compile
and send him one/some solution(s).
I will gladly post the answer(s) if there is interest.
Thanks!
Tanya
------------------------------------------------------------------------------
| A DDDD DDDD SSS | US MAIL: Tanya Katz |
| A A D D D D S | ADDS, Inc. |
| A A D D D D SS | 100 Marcus Blvd. |
| AAAAA D D D D S | Hauppauge, N.Y. 11788 |
| A A DDDD DDDD SSS | UUCP : ncrlnk!adds!tanya |
| | tanya.katz@adds.newyork.NCR.COM|
|Applied Digital Data Systems, Inc.| PHONE : (516) 231-5400 X430 |
------------------------------------------------------------------------------bo09+@andrew.cmu.edu (Brock Eugene Organ) (07/07/89)
Would anyone who frequently uses the 'macro' language supplied with
1-2-3 be able to answer my question about it:
Is there a way to reference (or point to) a range name with another
range name within a macro? Example:
'\v '{getlabel "name:", namebuf}
'/ rnc
@@(namebuf)
'~.{right}{down 2}~
{put @@(namebuf),1,1,"This is the new range"} <-- here is the error
The macro (\v) here asks the user for the name of a new range, and
creates a new range (the name of the range is whatever label the user
entered). The put statement is supposed to place a label inside of this
new range, but macro execution stops and gives an error in the put
statement. It specifically will not accept the @@(range) function as a
valid range.
I would hope to use this macro to dynamically create ranges; but if
there is no way to reference the newly created range then any macros
that use ranges are limited to one explicit range for which it applies.
Is there any way to use some type of function to represent any old
generic range?
Thank you for your time,
Brock Organ
(bo09@+andrew.cmu.edu)werner@aecom.yu.edu (Craig Werner) (06/12/90)
If it's in the manual, it's certainly escaped me...
I'd like to write a "simple" macro that prompts for six
consecutive values, plugs these values into six adjacent columns, and
then extends a graph set one row down.
I thought I had it, but after a time I realized that older values
came to resemble newer values. In other words, all the new rows were
references to the old rows, and hence all the data changed together.
Is there any way to combine {getnumber} with an absolute
reference to the current cell, and place a value there?
I assume that it's simple and I'm just missing it.
Is there a good book on macro programming in Lotus (really
Quattro Pro with Lotus 1-2-3 tree) as opposed to using the spreadsheet, a
skill I've already mastered.
--
Craig Werner (future MD/PhD, 4.5 years down, 2.5 to go)
werner@aecom.YU.EDU -- Albert Einstein College of Medicine
(1935-14E Eastchester Rd., Bronx NY 10461, 212-931-2517)
"Morphology is part science and part 'Ipse Dixit.' "