Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    convert .wk4 to Excel (Win XP Excel 2003)

    When I try to open the .wk4 file I get a "File format not valid" message. Would I have better luck importing to Access?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: convert .wk4 to Excel (Win XP Excel 2003)

    You'll only find out by trying, won't you?

  3. #3
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: convert .wk4 to Excel (Win XP Excel 2003)

    It is a three hour drive to the farm where the Lotus machine is located, so I had wanted to be as prepared as possible with alternatives when I go there Wednesday. Sorry.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: convert .wk4 to Excel (Win XP Excel 2003)

    Both Excel and Access should be able to import .wk4 files. If it fails for you, we can't say anything about the cause without seeing the file.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: convert .wk4 to Excel (Win XP Excel 2003)

    If the file can still be opened in Lotus, then you might try exporting it in some other format that Excel can handle. If the version of Lotus can create a HTML file, that might be a good choice. You could export it as a .csv file, but you will lose all formatting and macros.
    Legare Coleman

  6. #6
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: convert .wk4 to Excel (Win XP Excel 2003)

    Hi Legare,

    A better export format, which I think Lotus supports, is SYLK. This is the spreadsheet equivalent of Word's RTF, and retains cell formulae, formatting and values. I've no idea what happens to macros, though, but I wouldn't be surprised if they got lost in the translation, since they're rather application-dependent.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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