Using Lotus 1-2-3 macros
IAN R. SINCLAIR · Medical Entomology and Zoology · 1991
Part 1 Basic Macros: more background a label Macro other names documentation of a Macro the LEARN action limitations a formatting Macro using the @ commands debugging direct typing more extended Macro use. Part 2 Introducing Macro command: characters and commands assignment using (LET) using Put keyboard input waiting for a command designing the Macro design in detail planned pauses more complex copies erase and calc. Part 3 Working with files: opening text files open to real using (READLN) using the string converting string numbers example of string handling using the byte-pointer using (WRITE) using (Writeln) numbers in files. Part 4 Branch and loop: tests and conditions the (IF) test labelling the branch repeating action using repeating Macros approximate solutions by repetition designing for iteration an iterative Macro circular references subroutines a no-return subroutine using subroutines passing parameters the (FOR) loop a text sort macro using Dispatch. Part 5 Program construction: menus menu actions call and return menus data entry designing the Macro testing the Macro Macro design in more detail fundamentals outline plan foundation stones the main Macro first subroutines the tough stuf play away the (score) subroutine minor subroutines. Part 6 Miscellaneous topics: beep and indicate panel and windows borders, frames and graphs using (LOOK) getting the breaks loop interruptions error detection a simple example using SYSTEM commands indirection using a Macro library using hte library. Appendices: Lotus user group public domain software library suppliers of 1-2-3 and associated software.