Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
I've just been given the task of converting a very old Lotus 123
spreadsheet, with LOADS of macros, to MS Excel 2003. I don't really have a problem with the VBA programming, but can't find a listing of the old lotus menu structure for use in interpreting the macros. As an example, one cell of a multi-cell keyboard macro contains {GOTO}G3~/RFP~G3.G108~{GOTO}A3~/RFF~C13.C109~{GOTO}Y3~/RFF~Y3.Y109~. Although the {GOTO}G3~ seems fairly straight forward, /RFP~G3.G108~ does not. Does anyone know of a listing of the '/' menu commands so that I can begin to decipher what these macros do? Thanks in advance for your help. Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
I realise this wont give you a full map of 123 menustructure but might put you on the road.. even in Excel2003 it's still there. options/tools/transition set the / as menu key select the lotus 123 help option check Transition navigation keys now manually type a / in a cell a dialog with interactive menuing should pop up. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote in message : I've just been given the task of converting a very old Lotus 123 spreadsheet, with LOADS of macros, to MS Excel 2003. I don't really have a problem with the VBA programming, but can't find a listing of the old lotus menu structure for use in interpreting the macros. As an example, one cell of a multi-cell keyboard macro contains {GOTO}G3~/RFP~G3.G108~{GOTO}A3~/RFF~C13.C109~{GOTO}Y3~/RFF~Y3.Y109~. Although the {GOTO}G3~ seems fairly straight forward, /RFP~G3.G108~ does not. Does anyone know of a listing of the '/' menu commands so that I can begin to decipher what these macros do? Thanks in advance for your help. Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
I tried setting this up but don't have a lotus help option checkbox? Should
that be in the option/tools/transition dialog? Dave "keepITcool" wrote in message ... I realise this wont give you a full map of 123 menustructure but might put you on the road.. even in Excel2003 it's still there. options/tools/transition set the / as menu key select the lotus 123 help option check Transition navigation keys now manually type a / in a cell a dialog with interactive menuing should pop up. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote in message : I've just been given the task of converting a very old Lotus 123 spreadsheet, with LOADS of macros, to MS Excel 2003. I don't really have a problem with the VBA programming, but can't find a listing of the old lotus menu structure for use in interpreting the macros. As an example, one cell of a multi-cell keyboard macro contains {GOTO}G3~/RFP~G3.G108~{GOTO}A3~/RFF~C13.C109~{GOTO}Y3~/RFF~Y3.Y109~. Although the {GOTO}G3~ seems fairly straight forward, /RFP~G3.G108~ does not. Does anyone know of a listing of the '/' menu commands so that I can begin to decipher what these macros do? Thanks in advance for your help. Dave |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
Hi Dave:
Your Boss is still living €śback in the day€ť as pointed out by Don /rfp is /rfp = /range/format/percent and also /rff is /range/format/fixed and at that point the program would except a number indicating the decimal position. and {GOTO} is as you assume however it was a macro defined by 123 as are all instances you see in { } ~ is the enter symbol I tried to find a map of the menus in the old manuals but there are none and as were the old DOS menus they may go 1--whatever deep. The easiest way would be to go back in the warehouse and find an old computer that still has 123 loaded. Good Luck TK |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
Don,
I don't see it in my my version Excel 2003. Could it be I haven't installed this feature? Dave "Don Guillett" wrote in message ... I just checked xl97, xl97 & xl2002 and it's there for all toolsoptionstransition -- Don Guillett SalesAid Software "Dave" wrote in message ... I tried setting this up but don't have a lotus help option checkbox? Should that be in the option/tools/transition dialog? Dave "keepITcool" wrote in message ... I realise this wont give you a full map of 123 menustructure but might put you on the road.. even in Excel2003 it's still there. options/tools/transition set the / as menu key select the lotus 123 help option check Transition navigation keys now manually type a / in a cell a dialog with interactive menuing should pop up. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote in message : I've just been given the task of converting a very old Lotus 123 spreadsheet, with LOADS of macros, to MS Excel 2003. I don't really have a problem with the VBA programming, but can't find a listing of the old lotus menu structure for use in interpreting the macros. As an example, one cell of a multi-cell keyboard macro contains {GOTO}G3~/RFP~G3.G108~{GOTO}A3~/RFF~C13.C109~{GOTO}Y3~/RFF~Y3.Y109~. Although the {GOTO}G3~ seems fairly straight forward, /RFP~G3.G108~ does not. Does anyone know of a listing of the '/' menu commands so that I can begin to decipher what these macros do? Thanks in advance for your help. Dave |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
Thanks TK,
I'll keep looking. Dave "TK" wrote in message ... Hi Dave: Your Boss is still living "back in the day" as pointed out by Don /rfp is /rfp = /range/format/percent and also /rff is /range/format/fixed and at that point the program would except a number indicating the decimal position. and {GOTO} is as you assume however it was a macro defined by 123 as are all instances you see in { } ~ is the enter symbol I tried to find a map of the menus in the old manuals but there are none and as were the old DOS menus they may go 1--whatever deep. The easiest way would be to go back in the warehouse and find an old computer that still has 123 loaded. Good Luck TK |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
Don't think so but I don't have 2003...
-- Don Guillett SalesAid Software "Dave" wrote in message ... Don, I don't see it in my my version Excel 2003. Could it be I haven't installed this feature? Dave "Don Guillett" wrote in message ... I just checked xl97, xl97 & xl2002 and it's there for all toolsoptionstransition -- Don Guillett SalesAid Software "Dave" wrote in message ... I tried setting this up but don't have a lotus help option checkbox? Should that be in the option/tools/transition dialog? Dave "keepITcool" wrote in message ... I realise this wont give you a full map of 123 menustructure but might put you on the road.. even in Excel2003 it's still there. options/tools/transition set the / as menu key select the lotus 123 help option check Transition navigation keys now manually type a / in a cell a dialog with interactive menuing should pop up. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote in message : I've just been given the task of converting a very old Lotus 123 spreadsheet, with LOADS of macros, to MS Excel 2003. I don't really have a problem with the VBA programming, but can't find a listing of the old lotus menu structure for use in interpreting the macros. As an example, one cell of a multi-cell keyboard macro contains {GOTO}G3~/RFP~G3.G108~{GOTO}A3~/RFF~C13.C109~{GOTO}Y3~/RFF~Y3.Y109~. Although the {GOTO}G3~ seems fairly straight forward, /RFP~G3.G108~ does not. Does anyone know of a listing of the '/' menu commands so that I can begin to decipher what these macros do? Thanks in advance for your help. Dave |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
Your correct (i'm switching versions too often)
in excel XP: /Tools/Options tab Transition Settings ----------------------------------- Microsoft Excel menu or Help key : = / o Microsoft Excel menus X Lotus 123 help V Transition Navigation Keys Sheet Options ------------------------------ etc In Excel2003: the settings controls have been removed. I tried Programmatically: application.TransitionMenuKeyAction=xllotushelp application.TransitionMenuKey="/" executes without error, but no change on the UI and no reaction on the keypress. ouch.. I'll try and see if i can find or create a map of the menu's -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote in message : Don, I don't see it in my my version Excel 2003. Could it be I haven't installed this feature? Dave "Don Guillett" wrote in message ... I just checked xl97, xl97 & xl2002 and it's there for all toolsoptionstransition -- Don Guillett SalesAid Software "Dave" wrote in message ... I tried setting this up but don't have a lotus help option checkbox? Should that be in the option/tools/transition dialog? Dave "keepITcool" wrote in message ... I realise this wont give you a full map of 123 menustructure but might put you on the road.. even in Excel2003 it's still there. options/tools/transition set the / as menu key select the lotus 123 help option check Transition navigation keys now manually type a / in a cell a dialog with interactive menuing should pop up. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote in message : I've just been given the task of converting a very old Lotus 123 spreadsheet, with LOADS of macros, to MS Excel 2003. I don't really have a problem with the VBA programming, but can't find a listing of the old lotus menu structure for use in interpreting the macros. As an example, one cell of a multi-cell keyboard macro contains {GOTO}G3~/RFP~G3.G108~{GOTO}A3~/RFF~C13.C109~{GOTO}Y3~/RFF~Y3.Y109 ~. Although the {GOTO}G3~ seems fairly straight forward, /RFP~G3.G108~ does not. Does anyone know of a listing of the '/' menu commands so that I can begin to decipher what these macros do? Thanks in advance for your help. Dave |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
Dave,
I've typed it all out and put it a sheet. Tried to mail but it bounced. please contact me by email. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote : Thanks TK, I'll keep looking. Dave "TK" wrote in message ... Hi Dave: Your Boss is still living "back in the day" as pointed out by Don /rfp is /rfp = /range/format/percent and also /rff is /range/format/fixed and at that point the program would except a number indicating the decimal position. and {GOTO} is as you assume however it was a macro defined by 123 as are all instances you see in { } ~ is the enter symbol I tried to find a map of the menus in the old manuals but there are none and as were the old DOS menus they may go 1--whatever deep. The easiest way would be to go back in the warehouse and find an old computer that still has 123 loaded. Good Luck TK |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
Thanks again for your help. I appreciate your posting anything you may come
across. Dave "keepITcool" wrote in message ... Your correct (i'm switching versions too often) in excel XP: /Tools/Options tab Transition Settings ----------------------------------- Microsoft Excel menu or Help key : = / o Microsoft Excel menus X Lotus 123 help V Transition Navigation Keys Sheet Options ------------------------------ etc In Excel2003: the settings controls have been removed. I tried Programmatically: application.TransitionMenuKeyAction=xllotushelp application.TransitionMenuKey="/" executes without error, but no change on the UI and no reaction on the keypress. ouch.. I'll try and see if i can find or create a map of the menu's -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote in message : Don, I don't see it in my my version Excel 2003. Could it be I haven't installed this feature? Dave "Don Guillett" wrote in message ... I just checked xl97, xl97 & xl2002 and it's there for all toolsoptionstransition -- Don Guillett SalesAid Software "Dave" wrote in message ... I tried setting this up but don't have a lotus help option checkbox? Should that be in the option/tools/transition dialog? Dave "keepITcool" wrote in message ... I realise this wont give you a full map of 123 menustructure but might put you on the road.. even in Excel2003 it's still there. options/tools/transition set the / as menu key select the lotus 123 help option check Transition navigation keys now manually type a / in a cell a dialog with interactive menuing should pop up. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote in message : I've just been given the task of converting a very old Lotus 123 spreadsheet, with LOADS of macros, to MS Excel 2003. I don't really have a problem with the VBA programming, but can't find a listing of the old lotus menu structure for use in interpreting the macros. As an example, one cell of a multi-cell keyboard macro contains {GOTO}G3~/RFP~G3.G108~{GOTO}A3~/RFF~C13.C109~{GOTO}Y3~/RFF~Y3.Y109 ~. Although the {GOTO}G3~ seems fairly straight forward, /RFP~G3.G108~ does not. Does anyone know of a listing of the '/' menu commands so that I can begin to decipher what these macros do? Thanks in advance for your help. Dave |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for Lotus 123 menu equivalents
I tried replying to sender from your post but received a "host unkown
error". Try replying to this post but remove any "_" characters and the word "remove" from my reply address and it should go through. Thanks again for all the help. I really appreciate it! Dave Scott "keepITcool" wrote in message ft.com... Dave, I've typed it all out and put it a sheet. Tried to mail but it bounced. please contact me by email. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Dave wrote : Thanks TK, I'll keep looking. Dave "TK" wrote in message ... Hi Dave: Your Boss is still living "back in the day" as pointed out by Don /rfp is /rfp = /range/format/percent and also /rff is /range/format/fixed and at that point the program would except a number indicating the decimal position. and {GOTO} is as you assume however it was a macro defined by 123 as are all instances you see in { } ~ is the enter symbol I tried to find a map of the menus in the old manuals but there are none and as were the old DOS menus they may go 1--whatever deep. The easiest way would be to go back in the warehouse and find an old computer that still has 123 loaded. Good Luck TK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
German Excel Menu equivalents | Excel Discussion (Misc queries) | |||
Are there equivalents of wildcard characters to use in hyperlink f | Excel Worksheet Functions | |||
International Equivalents | Excel Worksheet Functions | |||
Lotus 1-2-3 help has been eliminated from the transition menu. D. | Excel Discussion (Misc queries) | |||
Lotus Macro Commands to VBA equivalents | Excel Programming |