- #Opening lotus 123 files how to#
- #Opening lotus 123 files manual#
- #Opening lotus 123 files software#
Here are a few things that will not convert and some tips to manually convert. Lotus 1-2-3 file formats use various filename extensions including 123, wks, wk1, wk2, wk3, wk4, some of these may open in the desktop applications of Collabora Online, LibreOffice and Apache OpenOffice and then saved into the OpenDocument format or other file formats. The conversion will not be very good unless you have very simple data and simple formulas common to both applications. You can not change the WK? to 123 as that file format is not supported by Excel so the file would not open in Excel properly.Īs was stated in this thread, you need to write and run a macro/script in another program to convert 123 files to XLS. This works because you can do it manually. Note that that method only converts the WK? files in the ConvertFolder's path to XLS format. While we have not verified the apps ourselves yet, our users have suggested 10 different 123 openers which you will find listed below.
#Opening lotus 123 files software#
Without proper software you will receive a Windows message 'How do you want to open this file' or 'Windows cannot open this file' or a similar Mac/iPhone/Android. Obviously, you need to change the string value for ConvertFolder. You will need a program compatible with the specific file you are trying to open, as different programs may use files with file extension 123 for different purposes. You need a suitable software like 1-2-3 from IBM to open a WK3 file. This is where you copy and paste the VBA code that Anne posted.
#Opening lotus 123 files how to#
You can get similar help on how to add a Module. There are many help sites that explain "How to run an Excel macro". You can get a membership free, by the way. Workbooks.Open FileName:=ConvertFolder & "\" & FileNameĪctiveWorkbook.SaveAs FileName:=ConvertFolder & "\" & Left(FileName, Len(FileName) - 3) & _ When I run 123.exe I get an empty spread-sheet with READY in the top left column. BTW, I cannot even figure out which version of Lotus-123 I am using.
#Opening lotus 123 files manual#
XLS spread-sheets I do not want a manual solution. 123.Īnyone know of such a batch converter or script that can be used in Lotus or Excel or vb to batch convert all of these?Ĭonst ConvertFolder = "C:\Documents and Settings\Kevin Jones\Desktop\Convert" Since I have to open hundreds of such files and then save them as. I was able to find serval batch converters for wk? files but none for. We have a copy of Lotus 1-2-3 but not the time to manually open each 123 files and save as xls. Lotus 1-2-3 is compatible with the Windows operating system. Although Lotus 1-2-3 is an older program, you can still obtain version 9.8 on the IBM website to open 123 file extensions. wk4 files are in subfolders within a folder called 'Client Files'. Shortly we shall acquire a Windows 8 computer in our family, which will also act as a test bed to see what old programmes will run on it. 123 files that are related to Lotus 1-2-3 can be opened using a variety of different programs. When in Lotus 1-2-3 and going to file>open, when you browse to the network drive you cannot see any folders that have spaces in their names. wk? which excel will open) that need to be converted. After moving their data from the 2003 server to the 2008 server, clients cannot open Lotus 1-2-3 (.wk4) files. This question was posted back in 2002 with no solution posted - just emailed vbscript from what I can tell.
0 kommentar(er)
