EDIT: PROBLEM SOLVED. SEE POST #3.
----------------------------------------------------------------------------------------------------
I have a big list of .wk1 files that I need to convert to .xls files, and I don't want to do it one-by-one.
Excel no longer recognizes .wk1 files.
Help on Lotus 123 macro commands is sparse.
You guys are smart, though. You might have a viable solution.
Here's my non-working-Lotus macro now (only two files long for the sake of testing):
This doesn't work.
Using the command {FILE-SAVE-AS?} doesn't quite work either because it brings up the dialog box where one would need to change the extension & then hit [enter].
I'm trying to avoid manual intervention.
Got any ideas?
----------------------------------------------------------------------------------------------------
I have a big list of .wk1 files that I need to convert to .xls files, and I don't want to do it one-by-one.
Excel no longer recognizes .wk1 files.
Help on Lotus 123 macro commands is sparse.
You guys are smart, though. You might have a viable solution.
Here's my non-working-Lotus macro now (only two files long for the sake of testing):
Code:
/fdC:\TopSecret\Output~
{FILE-OPEN abc1.wk1}{FILE-SAVE}abc1.xls~
{FILE-OPEN abc2.wk1}{FILE-SAVE}abc2.xls~This doesn't work.
Using the command {FILE-SAVE-AS?} doesn't quite work either because it brings up the dialog box where one would need to change the extension & then hit [enter].
I'm trying to avoid manual intervention.
Got any ideas?
Convert a bunch of .wk1 files to .xls files
0 commentaires:
Enregistrer un commentaire