I need some heavy help with converting a LOTUS 123 to Excel 2010 Macro... Please!

[HahnsPCs]

I have a Lotus 123 file with 3 sheets ("A", "Results", & "Graphing").

It has a Macro that copies the last row of column "A" on Sheet "A" to the next clean row on sheet "A", and makes some changes to the fields in that new copied row based upon some work in other fields...

The first part of this single Macro merely copies the last row of column "A" on Sheet "A" to the next clean row on sheet "A"

\a {goto}a:a1~
{end}{d}{end}{d}
/c{r 180}~{d}~
{d}

It's this NEXT part that's killing me to convert from Lotus 123 to Excel (and yes, it's a GREAT new Century from LOTUS! Ugh!)...

The Actual Lotus Macro continues as:

/cnewdate~~{r 2}/cnewnav~~
{goto}trc~
/cnewtotret~mstar~
/cnewnav~price2~
/readjyield~
/rvyield1~adjyield~{calc}
/rvyield2~adjyield~{calc}
/rvyield2~adjyield~{calc}
/rvyield2~adjyield~{calc}
{goto}macro~

The FIRST Line of this second part of the MACRO (/cnewdate~~{r 2}/cnewnav~~) takes the Value from "Results:BA3" (Named "Newdate") and copies it to the First Column "A:A(newly created row)" of the new row created in the first part of the MACRO, and then shifts over two columns ({r 2}), and takes the value from "Results:BB3" (named "newnav") and copies it there to "A:C(newly created row)"...

The SECOND Line of this second part of the MACRO ({goto}trc~) Simply goes to A:DU7 through A:DX22 but it doesn't appear to DO anything...

The THIRD Line of this second part of the MACRO (/cnewtotret~mstar~) copies the value of "Results:BC3" (/cnewtotret~) to "A:DV22" (mstar~)

The FOURTH Line of this second part of the MACRO (/cnewnav~price2~) copies the value of "Results:BB3" (/cnewnav~) to "A:DW25" (price2~)

The FIFTH Line of this second part of the MACRO (/readjyield~) simply deletes the value from "A:DX22" (/readjyield~)

The SIXTH Line of this second part of the MACRO (/rvyield1~adjyield~{calc}) Seems to make some calculation from "A:DW29" (/rvyield1~) and "paste special" using "Formulas as values" to "A:DX22" (adjyield~{calc})

The SEVENTH, EIGHTH, and TENTH Lines all seem to repeat to get an accurate result... I guess it was found that if the calculation was run once or twice it wasn't always accurate, where third times the charm... It some a similar bit of work like the SIXTH Line, just drawing from a different field... All 3 steps run /rvyield2~adjyield~{calc} to make some calculation from "A:DX29" (/rvyield2~) and "paste special" using "Formulas as values" to "A:DX22" (adjyield~{calc})

The TWELTH and FINAL Line of this second part of the MACRO ({goto}macro~) just seems to return to the location the Macro is written on "Results:BA1"

Again, any assistance GREATLY Appreciated!!!

 

[hiker95]

HahnsPCs,

It has been eons since I wrote macros for Lotus 123.


See this link:

[SOLVED] Converting from Lotus 123 to Excel 2010


There is a lot of information out there if you search the web for:

convert LOTUS 123 macro to Excel 2010 Macro

 

[HahnsPCs]

The link you provided was interesting, but sadly had no related Macro entries/conversions, but thank you anyway... I HAVE tried my luck looking on the web, and admittedly it's been AGES since I converted Lotus 123 to Excel but the searches ARE what brought me here...

 

[hiker95]

HahnsPCs,

Sorry I could not really help you.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else may be able to assist you.

 

[HahnsPCs]

Bump