excel can not read my lotus files that are saved in a 123
workbook file. if i open the file and save it as a *.wk3
or *.wk4 than excel can see the file. am i going to have
to go through all of my lotus files and resave. i have
over a 1000 files.
The short answer is YES, you're going to have to convert all your files with
123 extentions. Excel doesn't read them, and Microsoft is as likely to provide
a conversion filter as it is to open source Office.
Since it appears you still have 123, you'd be better off automating the
conversion effort in 123, using 123 to same .123 files in .XLS format (*NOT* any
WK? format). While there would still be some manual conversion required (not
all 123 @-functions or features have Excel equivalents), I've found that 123
does a more complete job of translating its own files into Excel format that
Excel does reading .WK? files.
If you use the console command
dir x:\*.123 /s/b/-P > 123List.txt
you'll generate a text file (named 123List.txt) containing the full pathnames of
all .123 files on your X: drive (change X to whatever the letter is for the
drive on which you have your .123 files). Import that file into 123, then write
either a macro or a script to cycle through that list, opening each of those
files (with Autoexec macros and startup scripts disabled), saving them as .XLS
files, then closing the files. If you need help writing such a macro or script,
you should ask for help doing that in
microsoft.public.excel.123quattro
since 123 classic macros and LotusScript are off-topic in this newsgroup.
