jpresweber
asked on
Batch convert .123 files to .xls files
This question was posted back in 2002 with no solution posted - just emailed script from what I can tell. I have over 1000 .123 files (not .wk? which excel will open) that need to be converted. We have a copy of Lotus 1-2-3 but not the time to manually open each 123 files and save as xls. I was able to find serval batch converters for wk? files but none for .123.
Anyone know of such a batch converter or script that can be used in Lotus or Excel or vb to batch convert all of these?
Anyone know of such a batch converter or script that can be used in Lotus or Excel or vb to batch convert all of these?
If your .123 files contain only data you may be able to do so. Please email me a copy of any .123 file. I will see what methods can be used.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This as well: http://www.ostfeld.com/lotus_123_to_microsoft_excel.htm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Apologies I am now an infrequent visitor to the Lotus123 forum of EE - thus the delay in even reading your question.
I have no idea whether this will work but for the sake of a few minutes playing around it's worth a try.
As Excel will open *.wk* files easily why not try renaming a *.123 file *.wk4 for example and then try opening it with Excel. I can't try it as my edition of Lotus123 creates *.wk4 files - it's so old!!
If it works then convert them all using the following command line in a DOS window (when you're in the correct directory) by using:
ren *.123 *.wk4
Patrick