Dec 062017
 
Lotus 1-2-3 macros from PC World.
File PCWORLD.ZIP from The Programmer’s Corner in
Category Lotus and other Spreadsheets
Lotus 1-2-3 macros from PC World.
File Name File Size Zip Size Zip Type
DEMO.WK1 3075 899 deflated
POINT.WK1 1567 285 deflated
README 2535 1210 deflated
SAMPLE.WK1 1706 387 deflated

Download File PCWORLD.ZIP Here

Contents of the README file



Lotus 1-2-3 Macros
------------------


FILES IN THE _123 DIRECTORY:

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


INSTRUCTIONS

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.


REFERENCES

"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


 December 6, 2017  Add comments

Leave a Reply