LIO2004 wrote...
First, STOP SHOUTING! All-caps is considered rude in newsgroups.
HOW CAN I CONVERT LOTUS 1-2-3 WORKBOOKS TO EXCEL
WITHOUT HAVING TO OPEN THE FILE IN LOTUS AND THEN
SAVING AS EXCEL FILE? I HAVE MANY FILES TO CONVERT TO
EXCEL AND IT WOULD TAKE TOO MUCH TIME TO CHANGE
FORMAT BY SAVING. IS THERE ANY WAY OUT.
How do you think any other piece of software would manage th
conversion? They'd need to open the 123 file and save it as an Exce
file, no? Do you believe they'd be significantly faster and/or easie
to use than 123 to do this?
If you mean .WK? files, Excel can open them itself, so no need t
convert them, though some formulas and formatting won't conver
automatically.
If you mean .123 files, YOU ARE OUT OF LUCK! (In this case, shoutin
for emphasis.) The *ONLY* software packages that support .123 files ar
123 itself, Quattro Pro 10 and later versions (actually QP9 may als
support them, but QP9 is bug ridden and best avoided), and (per it
marketing literature) DataViz's ConversionPlus. Since it seems yo
already have 123, the choice of which to use should be obvious.
As for taking too much time, use a macro and run it over night or ove
the weekend.
You'll need a list of all .123 files (since only .123 files need to b
converted by 123). Easiest to use a console prompt (aka DOS prompt) t
do this using a command like
dir X:\*.123 /s/b/-p > %TEMP%\123wblst.txt
Then open this text file in 123. Name the entire list of filename
WBLIST. Insert a new worksheet. Enter the following macro in A1..B11
range name labels in col A, macro code in col B, underscores represen
column separators.
\CONV _ /wgdanq
_ {goto}WBLIST~
\LOOP _ {if @cellpointer("Type")="b"}{quit}
_ {file-open @cellpointer("Contents")}
_ {-- "opened file becomes active workbook"}
_ {-- "check file type (2nd) arg in following line in Help"}
_ {file-sav
@replace(@cellpointer("Contents"),@length(@cellpointer("Contents"))-3,3,"xls"),"Exce
97 (xls)"}
_ {file-close "Yes"}
_ {-- "workbook containing this macro again active workbook"}
_ {d}
_ {branch \LOOP}
Use / rnlrA1..A3~ to set \CONV and \LOOP range names, then run th
\CONV macro. It may take a while to run, but it's the fastest way to d
what you want even if you don't believe so
