Excel 97

[Chong]

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}~

 

[Jim Rech]

You're trying to run a Lotus macro in Excel 2003. Unfortunately Lotus macro
support was dropped after Excel 97.

--
Jim
|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}~
|

 

[Don Guillett]

Looks like you need to change tools>options>transition
or vba

range("e12")=0
range("e13")=1
range("e11")=range("b1")
range("e14")=1
range("e11")=range("e11")-range("e13")

 

[Chong]

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

 

[Chong]

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]

You can send it to me and I'd be happy to do a VBA version for Excel 2003.

--
Jim
| 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 tools>options>transition
| > 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
| > (e-mail address removed)
| > | > >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}~
| > >
| >
| >

 

[Don Guillett]

Jim volunteered

 

[Chong]

Hi Jim,

Thanks in advance, i will send the file to (e-mail address removed).

Best Regards,
Chong

 

[Chong]

Hi Jim,

I have sent you the file. Wondering whether you received it ?

Regards,
Chong

 

[Chong]

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