+ Reply to Thread
Results 1 to 11 of 11

Create Excel File from Lotus

  1. 07-22-2021, 07:39 AM #1
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Create Excel File from Lotus

    Hi Everyone,

    I Have 2 Lotus 123 Files That I Use To Create a 4custa.prn file that gets used by another program to send prices to scales?

    Is There Any Way To Convert These Files To Excel And Keep The Functions the same?

    Hope Someone can Help Me

    Thank You
    Reply With QuoteRegister To Reply
  2. 07-22-2021, 07:49 AM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,378

    Re: Create Excel File from Lotus

    Search Google for: create excel file from lotus 123

    One example page: https://www.tech-faq.com/convert-lot...-to-excel.html

    Note that, if the file has a .123 file extension, you need to rename it with a .wk4 extension.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 07-22-2021, 08:05 AM #3
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Re: Create Excel File from Lotus

    Hi Trevor,

    I Tried That but it removes all macros etc from the file so I have arrived at a bit of a dead end.
    Reply With QuoteRegister To Reply
  4. 07-22-2021, 09:23 AM #4
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Re: Create Excel File from Lotus

    Hi Again Trevor,

    I Have The File Open In Excel Now But No Formulas Etc Will Have To Do Everything From Scratch.

    I Have A Product Code, Description, Price and Department That All Need To Have A Specific String Of Characters Added otherwise the Diginet Software Won't Accept It.
    Reply With QuoteRegister To Reply
  5. 07-22-2021, 10:02 AM #5
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,378

    Re: Create Excel File from Lotus

    Can you post a sample .123 file to see what anyone can do with it?
    Reply With QuoteRegister To Reply
  6. 07-22-2021, 10:09 AM #6
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Re: Create Excel File from Lotus

    Hi TMS

    Is There another way to upload the File I Cannot Attach it here it Says Invalid File.

    Thank you
    Reply With QuoteRegister To Reply
  7. 07-22-2021, 10:42 AM #7
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,378

    Re: Create Excel File from Lotus

    Maybe try zipping it up.
    Reply With QuoteRegister To Reply
  8. 07-22-2021, 10:44 AM #8
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Re: Create Excel File from Lotus

    Forgot about that sorry
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 07-22-2021, 12:08 PM #9
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,378

    Re: Create Excel File from Lotus

    OK, good news and bad news. The good news is that the .123 files WILL open in LibreOffice (which I had forgotten I had installed ). From there, you can save the file as an .xls, .xlsx or .xlsm file. The bad news is that I can't see any macros ... but I'm not sure if we're talking about the same thing.

    There ARE formulae, which include functions, which neither LibreOffice nor Excel can cope with. That said, if you know what they are meant to do, you can probably re-write them as Excel formulae.

    For example:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    You can download LibreOffice for free. If it would help, I can upload the converted files.
    Reply With QuoteRegister To Reply
  10. 07-22-2021, 01:06 PM #10
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Re: Create Excel File from Lotus

    Hi TMS

    Thanks a million will give it a shot
    Reply With QuoteRegister To Reply
  11. 07-22-2021, 02:24 PM #11
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,378

    Re: Create Excel File from Lotus

    You're welcome. Thanks for the rep.

    Here are your Excel files

    Note that I have removed a LOT of empty cells from Scale.xlsm
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to create Lotus email from Excel, possibly add Sheet as attachment.
    By asmeltz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2015, 01:34 PM
  2. [SOLVED] How to create Lotus reminder from excel data
    By Amolvijay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2014, 06:39 AM
  3. Excel macro that uses Lotus 1-2-3 file?
    By thedon_1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2008, 06:46 AM
  4. lotus file into excel
    By jenny52 in forum Excel General
    Replies: 1
    Last Post: 11-07-2007, 07:53 AM
  5. Converting a Lotus 123 file to Excel
    By Greenback in forum Excel General
    Replies: 2
    Last Post: 03-31-2006, 06:45 AM
  6. converting a lotus file into excel.
    By nela in forum Excel General
    Replies: 2
    Last Post: 03-22-2006, 02:00 PM
  7. [SOLVED] Can't open Lotus 123 file in Excel
    By Coni in forum Excel General
    Replies: 1
    Last Post: 03-05-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1