Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

How do I convert macros and formulas from Lotus to Excel?

by Jul 4, 2014 4:35AM PDT

I may be the last person in the U.S. still using Lotus 123 software, but with many hundreds of macros and tens of thousands of formulas in a complex web of interrelated files all of which fail spectacularly in Excel, to convert to Excel would take me six months or more of very hard work just to get back to my current level of functionality. Since XP was the last version of Windows in which Lotus works I wanted to ask if anyone knew of any software that would facilitate the conversion or have any other suggestions.

Running XP in virtual boxes doesn't really help since I'm routinely importing data from on-line sites or other software to Lotus.

I'm ok with using XP even with support being discontinued but at some point new software won't even run on XP.

Any suggestions would be really appreciated.

Discussion is locked

5 Posts
- Collapse + Expand Details
- Collapse -
Clarification Request
Why not try the latest Lotus spreadsheet?
by r. proffitt Forum moderator Jul 4, 2014 4:46AM PDT

And about macros and such. Over the years we banished macros as they can be a support headache. We moved to in house apps.
Bob

- Collapse -
Answer
Re: Lotus 1-2-3
by Forum moderator Jul 4, 2014 4:59AM PDT
- Collapse -
lotus r5
by pyramid14 Jul 4, 2014 7:24AM PDT

Thank you. I should have been more precise. I'm using 123 release 5 which won't even start installing in Windows 8.1. I've tried. 123r9 will (I have both) but even those two versions of Lotus aren't quite compatible. Opening an r5 file in r9 has thousands of errors. I was hoping for some software that can help with conversion or else a means of installing r5.

Thank you again.

- Collapse -
Remember R5 is that old.
by r. proffitt Forum moderator Jul 4, 2014 7:32AM PDT

123R5 as it is incompatible with a Windows install that has the Novell Client. Over a decade later I never read if IBM ever fixed that.

So in short, it may take IBM to help you install this.
Bob

- Collapse -
Answer
The problem is Lotus macros are basically
by Aug 7, 2014 5:00AM PDT

Key commands for the lotus menus. Office uses VBA Visual basic for applications.

Google converting lotus 123 macros to visual basic for applications and you will find some consultants. If your company is willing to pay for the conversion will show how much they really need them converted.

Back to Office & Productivity Software forum

CNET Forums

Operating Systems
Software
Electronics & Gadgets
Hardware
Tablets & Mobile Devices
General Help
Brand Forums
Roadshow Autos
Off Topic

Other Forums

Forum Info