Here are a few things that will not convert and some tips to manually convert. 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. Obviously, you need to change the string value for ConvertFolder. Microsoft has stated few workaround for opening WK4 files in Excel. You can do a phrase search for the same to locate such failed conversions. So it may be as simple as a SAVE AS to Excel format. However, the current versions of Lotus still save as Lotus format. Excel Details: Excel 2007 no longer handles 123 format files natively. This is where you copy and paste the VBA code that Anne posted. Users can convert Lotus documents to Microsoft Excel documents by using any of the following services. Convert Lotus 123 to Excel - Microsoft Community.
#Convert lotus 123 excel how to
You can get similar help on how to add a Module. 123) can be a little tricky in modern spreadsheet editors. Opening or even conversion of old Lotus 1-2-3 spreadsheets (.
#Convert lotus 123 excel software
We have found 3 software records in our database eligible for. There are many help sites that explain "How to run an Excel macro". Convert Lotus 1-2-3 spreadsheet to Microsoft Excel Open XML workbook and spreadsheet. You can get a membership free, by the way. Workbooks.Open FileName:=ConvertFolder & "\" & FileNameĪctiveWorkbook.SaveAs FileName:=ConvertFolder & "\" & Left(FileName, Len(FileName) - 3) & _ 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" I was able to find serval batch converters for wk? files but none for.
![convert lotus 123 excel convert lotus 123 excel](https://s1.manualzz.com/store/data/037585349_1-b0ce8744e65f710ce989ef7a5d9f5d0a-360x466.png)
We have a copy of Lotus 1-2-3 but not the time to manually open each 123 files and save as xls. wk? which excel will open) that need to be converted. This question was posted back in 2002 with no solution posted - just emailed vbscript from what I can tell.