Computer Hope
Software => Computer software => Topic started by: henryjr on March 04, 2018, 06:11:29 PM
-
A few years ago, I had windows XP and Excel on MS office. I also had several spread sheets on LOtus version 4. When I imported a lotus file into excel the result was the convenience of Lotus and the power of Excel. I was able to create macros using the lotus keystrokes. Running macros and editing was a snap. I would like to find how I can get something like this now with Windows 10.
-
What is it you gain by having both Lotus and Excel and switching between the 2? As far as I know, Excel can do everything Lotus could do and more. I was a big-time user of Lotus back in the 90's but switched to Excel and never missed Lotus. MS gave Excel the ability to respond to the Lotus "/" commands and even has this capability in the latest version of Office.
Excel has Lotus compaibility options under Advanced options:
[attachment deleted by admin to conserve space]
-
Open Office and Libre Office are free options, but not sure how easy it is to import macro use. I use Open Office myself, but I havent played with macro use.
https://www.libreoffice.org/
https://www.debugpoint.com/2014/09/writing-a-macro-in-libreoffice-calc-getting-started/
https://www.openoffice.org/
https://wiki.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Creating_a_simple_macro
I had Lotus 1-2-3 back in the mid 1990s as well, then in college I got Office 2000 and switched to Excel. But when introduced to Open Office about 5 years later and it was FREE, I made the leap to free office software and only use Microsoft Office at work.
-
Running macros and editing was a snap. I would like to find how I can get something like this now with Windows 10.
I believe the version of Windows is irrelevant here, unless you want to know whether a very old version of Excel or one of the freeware choices will work with Windows 10. Otherwise, your question is really about Excel, and perhaps certain versions of Excel, not about Windows 10.