Category : Lotus and other Spreadsheets
Archive   : LTSTIPS2.ZIP
Filename : FILESAVE.123

Multifile Macros
(PC Magazine Vol 3 No 17 Sept 4, 1984 User-to-User)

Spreadsheet users can work on two or more files interactively by
adding a simple keyboard macro to each file. The macro added to FILEA
is: /FSFILEA~R~/FRFILEB~~. When this macro is invoked, FILEA is saved
and FILEB is retrieve. FILEB has the marco: /FSFILEB~R~/FRFILEA~~
which saves FILEB and then retrieves FILEA. Move than two files can be
used by adding macros to direct the retrieve to the specific file. The
R snuggled between two tildes in the middle of these macro lines stands
for Replace; you must Save the files prior to executing the macro, or
you will be left with an extra R somewhere.

-----------------------------------------------------------------
Saving 123 Files
(PC Magazine Vol 4 No 7 April 2, 1985 Spreadsheet Clinic)
(article originally titled "Worksheet Security")

When you save a file to disk, 123 checks if a file with that name
already exists. If not, the save operation is completed and control
returned to you. If the file has been previously saved, you're
prompted to cancel the Save command or replace the old file by
overwriting it with the new one. The advantage of adding an escape
code after the Save command as shown below is that the person writing
a macro isn't burdened with knowing whether or not a file already
exists. It may be important to verify a save operation and then return
control to a macro. The MENU.SAVE submenu below appears when you choose
Save from the main menu. This process emulates 123's verification step.

1
2
3
4 MENU.MAIN
5 Save Print Quit
6 Save this file to disk Print date in REPORT range Exit to DOS
7 /xmMENU.SAVE~ /pprREPORT~agq /qy
8 /xmMENU.MAIN~
9
10
11 MENU.SAVE
12 Cancel Replace
13 Return to Main Menu Save even if file already exists
14 /xmMENU.MAIN~ /fsTHISFILE~R
15 /xmMENU.MAIN~
16

-----------------------------------------------------------------
Using a Macro to Save a Worksheet
(PC Magazine Vol 4 No 22 October 29, 1985 Spreadsheet Clinic)

When you write a 123 macro that saves a worksheet, you may not
always know whether there is a file of that name already on disk. If
there is, the program will not immediately make the save. Instead, it
will give you a menu choice: Cancel the save operation or Replace the
file on disk. With most macros you're likely to want to replace any
existing file. However, if you include an r as a part of the macro
itself and the r isn't needed, it can cause an error in the next step
of the macro. On the other hand, if you leave out the r and happen to
need it, the macro processor will read the next line of the macro
instead of the r, and you will get a different error.
The macro below solves this problem. When the r is needed, it's
used, and the {esc} in line 7 does no harm at all to the worksheet.
When the r isn't needed, the {esc} cancels it before it can do any
irreparable damage.
Editor's Note: This trick will work just as well if you don't
want the macro to overwrite a file of the same name that is already
on disk. All you have to do is to change the letter r in line 7 to c.

B C D
3 \P /xlEnter the name of the file: ~c5~
4 /fs
5
6 ~
7 r{exc}
8
9 (macro .....
10
11 .....continues)