Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: LOTUS AND EXCEL  (Read 364 times)

0 Members and 1 Guest are viewing this topic.

henryjr

    Topic Starter


    Newbie

    • Experience: Familiar
    • OS: Windows 10
    LOTUS AND EXCEL
    « 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.

    strollin



      Apprentice
    • Thanked: 50
      • Yes
    • Computer: Specs
    • Experience: Guru
    • OS: Other
    Re: LOTUS AND EXCEL
    « Reply #1 on: March 05, 2018, 06:01:35 AM »
    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:

    DaveLembke



      Sage
    • Inventor of the Magna-Broom 3000 =)
    • Thanked: 590
    • Certifications: List
    • Computer: Specs
    • Experience: Expert
    • OS: Windows 7
    Re: LOTUS AND EXCEL
    « Reply #2 on: March 05, 2018, 08:30:42 AM »
    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.

    soybean



      Genius
    • The first soybean ever to learn the computer.
    • Thanked: 467
    • Computer: Specs
    • Experience: Experienced
    • OS: Windows 10
    Re: LOTUS AND EXCEL
    « Reply #3 on: March 08, 2018, 08:29:10 AM »
    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.