Welcome to Ed Ingram's Basic Lotus Page
This Lotus page by Ed Ingram of Dawsonville, Ga.
 |
-------Ed006@aol.com------- |
|
This page contains basic information on Lotus
macros. Refer to the other
Lotus web pages for List of Commands, Formulas, and
complicated Macros.
Simple macros will be discussed here. What is a macro?
On any Lotus
spreadsheet, one can select a cell, name it, put macro
commands in it, execute
it and the macro commands will be performed.
Let's do a very simple macro. On a
spreadsheet, pick a cell. Name the cell \A
by entering the following keystrokes: /RNC\a~
The ~ here and always
means the 'ENTER' key. In the cell put the following:
{R}{D 5} Now press
the 'Ctrl' key and hold it down while pressing the letter
'a'. The cursor should
move right one column and down five rows each time
Ctrl+a is pressed. In
macro language, \A means Ctrl+A. I
would write this macro as follows:
{if =1} \A
This macro moves the cursor right and down.
{R}{D 5}{return}
Here's a simple macro that might be useful.
Create an address list with the
person's name in column 'b', the street address in
column 'c', and the City, State
zip in column 'd'. Next name the envelope print range
'envelope'. Name the
cells that get the name and address 'name',
'street', and 'city'. Put an 'x'
in column 'a' beside the ones to be printed. Each time
\P is executed, an
envelope will be printed and the flag will be erased.
|
{if =1} \P Prints envelopes for addresses flagged in column 'A'. |
|
{goto}a1~{end}{D}{if @cellpointer("row")>8000}{home}{quit} |
|
/RE~{R}{let name,@cellpointer("contents")} |
|
{R}{let street,@cellpointer("contents")} |
|
{R}{let city,@cellpointer("contents")} |
|
{select envelope}{print "selection";1;9999;1;1}{return} |
I'll try to take time to expand on this Basic Lotus sheet later.
|
 |
Our Main Index Page contains links to all of our web pages.
