Category : Lotus and other Spreadsheets
Archive   : PCWORLD.ZIP
Filename : README

Output of file : README contained in archive : PCWORLD.ZIP

Lotus 1-2-3 Macros


DEMO.WK1 -S macro totals columns
POINT.WK1 -C macro automates decimal points
SAMPLE.WK1 -P macro demonstrates menu making techniques


Load POINT.WK1 into Lotus 1-2-3 and position the cursor on a blank
cell somewhere below the macro text. Type a few numbers like 1234
and 7896. Then, press -C to activate the decimal-point macro.
Now, type a few more values. Notice that the decimal point is
now automatically inserted.

As SAMPLE.WK1's -P macro demonstrates, the Lotus menu macro
command /XMmessage~location~ is handy for more than just making
menus. For the purposes of this demo, cell A6 holds the macro's
range name as the label \P. The macro itself begins in the cell to
the right, B6, with a /XM command that specifies the cell containing
the message to be highlighted, in this case, cell B8. The cell below
the /XM command is blank to let you press .

When you press -P to start the macro, the contents of the cell
under the message is displayed on the control panel beneath the
message. After 1-2-3 displays the message, the macro pauses.
Pressing at this time cancels printing because macro execution
falls to the cell below the /XM command, which, because it is empty,
halts the macro. Pressing continues execution at the cell
below the second message line, cell B10, which contains the commands
to print a previously defined range named REPORT.

DEMO.WK1 illustrates how to simplify writing Lotus 1-2-3 formulas to
sum columns with subtotals, usually a time-consuming and error-prone
task. To use the macro, assign a range name SUM to the column's
range and a second range name TARGET where the total should appear.
When you then press -S, a formula string is created at TARGET
with an @SUM() function for the SUM range. An EDIT function changes
this temporary string into a formula by deleting the label prefix.
The macro assumes that subtotals are preceded by a line drawn with
the \- command, as is usually the case. The @CELLPOINTER("CONTENTS")
function searches for rows with dashes, locating subtotals, which are
then subtracted from the sum.


"Making a Point With 1-2-3" by L. D. Mashburn, June 1988
"Prompting With 1-2-3 Menus" by Don Nummi, Jr., March 1988
"1-2-3 Totem Pole Totals" by Brian T. Copeland, December 1988

  3 Responses to “Category : Lotus and other Spreadsheets
Archive   : PCWORLD.ZIP
Filename : README

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: