General discussion


Lotus Smart Suite to Excel 2k

By kentward ·
Our company used MS Office (97, 2k and XP) accross the board (about 72 machines). The exception (isn't ther always one) was the Comptroller and the CFO. After the Comptroller quit we hired a new lady to fill the position. She is a 'Softie and that makes things easier on me?? Anyway the former comptroller saved many things not as Lotus 123 files but as Lotus Smartsuite 123 v9 folders. The new comptroller is using Office 2k SP1a. There is not a direct way to opent ht e folders in 2k and Smart Suite allows to be saved as Excel 97 spreadsheets. The new Comptroller has about 125 folders to convert. I have her converting one at a time as she uses them, however I was hoping someone might know a better faster way.
Your time is greatly appreciated.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Try a macro...?

by rjjder In reply to Lotus Smart Suite to Exce ...

Since you already have a process in place, you might try recording a macro in which you open the original file and save it as needed.
Then, with help if necessary, edit the macro code to loop through all files of that type or in that storage location folder.
I don't know if a batch converter is available as an add-in or other option in this version.
Moving all the original files to one folder, by themselves, might facilitate the macro approach.
We did this at my office for converting Wordperfect and amipro to MS Word a few years ago.
Sorry I don't have the code to provide.
Hope this helps...

Back to Windows Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums