| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97
I have an Excel 97 with the following coding in the cell. By press Ctrl-A,
the formula will be calculated accordingly. But when i open this file in Excel 2003, it doest function anymore after i press Ctrl-A. Please help. {LET E12,0}~ {LET E13,1}~ {LET E11,B11}~ {LET E14,1}~ {LET E11,E11-E13}~ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97
You're trying to run a Lotus macro in Excel 2003. Unfortunately Lotus macro
support was dropped after Excel 97. -- Jim "Chong" wrote in message ... |I have an Excel 97 with the following coding in the cell. By press Ctrl-A, | the formula will be calculated accordingly. But when i open this file in | Excel 2003, it doest function anymore after i press Ctrl-A. Please help. | | {LET E12,0}~ | {LET E13,1}~ | {LET E11,B11}~ | {LET E14,1}~ | {LET E11,E11-E13}~ | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97
Looks like you need to change toolsoptionstransition
or vba range("e12")=0 range("e13")=1 range("e11")=range("b1") range("e14")=1 range("e11")=range("e11")-range("e13") -- Don Guillett Microsoft MVP Excel SalesAid Software "Chong" wrote in message ... I have an Excel 97 with the following coding in the cell. By press Ctrl-A, the formula will be calculated accordingly. But when i open this file in Excel 2003, it doest function anymore after i press Ctrl-A. Please help. {LET E12,0}~ {LET E13,1}~ {LET E11,B11}~ {LET E14,1}~ {LET E11,E11-E13}~ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97
Hi Don Guillett,
If i were to provide you the excel file with those Lotus macro, are you able to help me to convert them as vba ? Best Regards, Chong "Don Guillett" wrote: Looks like you need to change toolsoptionstransition or vba range("e12")=0 range("e13")=1 range("e11")=range("b1") range("e14")=1 range("e11")=range("e11")-range("e13") -- Don Guillett Microsoft MVP Excel SalesAid Software "Chong" wrote in message ... I have an Excel 97 with the following coding in the cell. By press Ctrl-A, the formula will be calculated accordingly. But when i open this file in Excel 2003, it doest function anymore after i press Ctrl-A. Please help. {LET E12,0}~ {LET E13,1}~ {LET E11,B11}~ {LET E14,1}~ {LET E11,E11-E13}~ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97
Hi Jim Rech,
How do i go about in order for me to make use of the Lotus macro in Excel 2003? Meaning i need to convert it as vba ? Regards, Chong "Jim Rech" wrote: You're trying to run a Lotus macro in Excel 2003. Unfortunately Lotus macro support was dropped after Excel 97. -- Jim "Chong" wrote in message ... |I have an Excel 97 with the following coding in the cell. By press Ctrl-A, | the formula will be calculated accordingly. But when i open this file in | Excel 2003, it doest function anymore after i press Ctrl-A. Please help. | | {LET E12,0}~ | {LET E13,1}~ | {LET E11,B11}~ | {LET E14,1}~ | {LET E11,E11-E13}~ | |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97
You can send it to me and I'd be happy to do a VBA version for Excel 2003.
-- Jim "Chong" wrote in message ... | Hi Don Guillett, | | If i were to provide you the excel file with those Lotus macro, are you able | to help me to convert them as vba ? | | Best Regards, | Chong | | "Don Guillett" wrote: | | Looks like you need to change toolsoptionstransition | or vba | | range("e12")=0 | range("e13")=1 | range("e11")=range("b1") | range("e14")=1 | range("e11")=range("e11")-range("e13") | | -- | Don Guillett | Microsoft MVP Excel | SalesAid Software | | "Chong" wrote in message | ... | I have an Excel 97 with the following coding in the cell. By press Ctrl-A, | the formula will be calculated accordingly. But when i open this file in | Excel 2003, it doest function anymore after i press Ctrl-A. Please help. | | {LET E12,0}~ | {LET E13,1}~ | {LET E11,B11}~ | {LET E14,1}~ | {LET E11,E11-E13}~ | | | |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97
Hi Jim,
Thanks in advance, i will send the file to . Best Regards, Chong "Jim Rech" wrote: You can send it to me and I'd be happy to do a VBA version for Excel 2003. -- Jim "Chong" wrote in message ... | Hi Don Guillett, | | If i were to provide you the excel file with those Lotus macro, are you able | to help me to convert them as vba ? | | Best Regards, | Chong | | "Don Guillett" wrote: | | Looks like you need to change toolsoptionstransition | or vba | | range("e12")=0 | range("e13")=1 | range("e11")=range("b1") | range("e14")=1 | range("e11")=range("e11")-range("e13") | | -- | Don Guillett | Microsoft MVP Excel | SalesAid Software | | "Chong" wrote in message | ... | I have an Excel 97 with the following coding in the cell. By press Ctrl-A, | the formula will be calculated accordingly. But when i open this file in | Excel 2003, it doest function anymore after i press Ctrl-A. Please help. | | {LET E12,0}~ | {LET E13,1}~ | {LET E11,B11}~ | {LET E14,1}~ | {LET E11,E11-E13}~ | | | |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97
Hi Jim,
I have sent you the file. Wondering whether you received it ? Regards, Chong "Jim Rech" wrote: You can send it to me and I'd be happy to do a VBA version for Excel 2003. -- Jim "Chong" wrote in message ... | Hi Don Guillett, | | If i were to provide you the excel file with those Lotus macro, are you able | to help me to convert them as vba ? | | Best Regards, | Chong | | "Don Guillett" wrote: | | Looks like you need to change toolsoptionstransition | or vba | | range("e12")=0 | range("e13")=1 | range("e11")=range("b1") | range("e14")=1 | range("e11")=range("e11")-range("e13") | | -- | Don Guillett | Microsoft MVP Excel | SalesAid Software | | "Chong" wrote in message | ... | I have an Excel 97 with the following coding in the cell. By press Ctrl-A, | the formula will be calculated accordingly. But when i open this file in | Excel 2003, it doest function anymore after i press Ctrl-A. Please help. | | {LET E12,0}~ | {LET E13,1}~ | {LET E11,B11}~ | {LET E14,1}~ | {LET E11,E11-E13}~ | | | |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97
Hi Don,
Are you able to help on this ? As i sent my file to Jim but i cant get any reply from him at all. Can i send my file to you instead ? Regards, Chong "Don Guillett" wrote: Jim volunteered -- Don Guillett Microsoft MVP Excel SalesAid Software "Chong" wrote in message ... Hi Don Guillett, If i were to provide you the excel file with those Lotus macro, are you able to help me to convert them as vba ? Best Regards, Chong "Don Guillett" wrote: Looks like you need to change toolsoptionstransition or vba range("e12")=0 range("e13")=1 range("e11")=range("b1") range("e14")=1 range("e11")=range("e11")-range("e13") -- Don Guillett Microsoft MVP Excel SalesAid Software "Chong" wrote in message ... I have an Excel 97 with the following coding in the cell. By press Ctrl-A, the formula will be calculated accordingly. But when i open this file in Excel 2003, it doest function anymore after i press Ctrl-A. Please help. {LET E12,0}~ {LET E13,1}~ {LET E11,B11}~ {LET E14,1}~ {LET E11,E11-E13}~ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
