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

Output of file : DATE.WK1 contained in archive : SRBMACRO.ZIP
'–* '" /ÿÿ q HA d GDATE  GDATEL  GNEXTG\Dÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ†ÿÿ±0ÿÿÿÿÿÿÿÿì ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$%ò ** LATEST CONTROLS BY DUE DATE **|I:\GROUP\PBB\ASSIGNME.WK1|PAGE # &ò '( (
LB)'*ÿÿÿÿÿÿÿÿ-·ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq ÿ'\d5ÿ'{GETLABEL "Enter date as (mm/dd/yy): ",DATEL}~)ÿ'{IF @ISERR(DATE)}{beep}{BRANCH \d}ÿ'/rvDATE~~/rfd4~ÿ'{MENUBRANCH next} ÿ'NEXTÿ'Enter another? ÿ'Right ÿ'Left ÿ'Down ÿ'Noÿ'Please Chooseÿ'Move Right and continue.ÿ'Move Left and continue.ÿ'Move Down and Continue.ÿ'Quit Workingÿ'{MenuBranch NEXT}ÿ'{RIGHT}{BRANCH \d}ÿ'{LEFT}{BRANCH \d}ÿ'{DOWN}{BRANCH \d}
ÿ'{QUIT} ÿ 'datelÿ '09/15/88 ÿ 'dateÿ @¤ß@€þŸM
ù À£ß@Fÿ'This macro will convert a date entered as MM/DD/YY to the LotusEÿ'serial number so it can be used by the Lotus formulas and alsoGÿ'formatted using the "/ Range Format Date" commands. By changingCÿ'the "4" on the third line above to a "1", or "2", or "3" you<ÿ'can change the format of the cell containing the dateÿ'automatinally.?ÿ'To invoke the macro hold down the macro key (Alt on most(ÿ'computers) and press the "d" key.Fÿ'If you combined this with another spreadsheet you will have to Dÿ'name the column to the right of the \d. To do this place theAÿ'cursor on the \d 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 \d with the names in the column#ÿ'with the names under the \d. ò" ù" ù$

  3 Responses to “Category : Lotus and other Spreadsheets
Archive   : SRBMACRO.ZIP
Filename : DATE.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: