Category : Lotus and other Spreadsheets
Archive   : SRBMACRO.ZIP
Filename : LEARN.WK1

 
Output of file : LEARN.WK1 contained in archive : SRBMACRO.ZIP
$– $/ÿÿ q H@d GENTRY1GENTRY2  GKEYGLEARNGLINE1GLINE2GLOOP1GLOOP2  GNEXTG\Lÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$%ò&ò'( (
LB)'*ÿÿÿÿÿÿÿÿ-·ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq ÿ'\lÿ'{Let LINE1,""}ÿ'{Let LINE2,""} ÿ'LOOP1ÿ'{Get KEY}ÿ'{Let ENTRY1,KEY}
ÿ'ENTRY1ÿ'~+ÿ'{If @LENGTH(LINE1)>230}{Branch NEXT}ÿ'{Let LINE1,LINE1&ENTRY1}ÿ'{Branch LOOP1} ÿ'NEXTÿ'{Let LINE2,KEY} ÿ 'LOOP2ÿ '{Get KEY}ÿ
'{Let ENTRY2,KEY}
ÿ 'ENTRY2ÿ '{Let LINE2,LINE2&ENTRY2}$ÿ
'{IF @LENGTH(LINE2)>230}{QUIT}ÿ'{Branch LOOP2}
ÿ'KEYÿ'~ ÿ'LINE1ÿ'~ ÿ'LINE2ÿ'Dÿ'This is the macro that Lotus forgot. How many times have youAÿ'been working on a macro only to forget the letter sequence=ÿ'necessary for your macro. This macro will record yourDÿ'keystrokes in LINE1 and LINE2 above. These lines can then be>ÿ'copied directly into your macro and will work as if youAÿ'had keyed them yourself. This macro will only capture twoBÿ'lines of 230 characters each. It can of course be modified,ÿ'to capture as many lines as you wish.?ÿ'To invoke the macro hold down the macro key (Alt on most(ÿ'computers) and press the "l" key.Fÿ'If you combined this with another spreadsheet you will have to Dÿ 'name the column to the right of the \l. To do this place theAÿ!'cursor on the \l and press slash (/), Range (R), Name (N),Fÿ"'Lables (L), Right (R), Page Down and Enter. THis will name theAÿ#'column to the right of the \l with the names in the columnÿ$'containing the \l.

  3 Responses to “Category : Lotus and other Spreadsheets
Archive   : SRBMACRO.ZIP
Filename : LEARN.WK1

  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: http://www.os2museum.com/wp/mtswslnk/