Convert Symphony to Excel

Hi,

First post on this forum, and I wouldn't waste your time, but...

I've been given several 3.5" diskettes (remember them)? with a whole bunch of .WR1 extension files on them, which I believe is Lotus Symphony. The owner of the data has asked me to get the data off of the drives and to convert them to Excel.

I had a 3.5" drive so said I'd have a go at the task...

I managed to get the data onto my HDD and then did the usual scour for conversion software and that's where I've got stuck! File.extensions.com sent me to Softronic for a trial version of ABC 123 converter, Installed it but could not do anything with the trial version and the support site is now defunct, I also can't find any alternative software to do the job and Excel can't make head nor tail of the files.

The guy who I'm doing it for is disabled and also has to look after his, even more, disabled brother and all the files are old important data he needs, so any help would be seriously appreciated.

Many thanks,



Iain

...also worth mentioning that the data is all password protected too... :/

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice may result in an infraction in the future.

I have changed it for you, today. Please read the forum rules you agreed to when you joined this forum and abide by them in the future.)

Look at this link that AlphaFrog provided a few years ago.

https://www.mrexcel.com/forum/excel-...s-wr1-xls.html

Ignoring the code, have you tried opening one of the files in Excel?

Have you tried getting hold of a copy of Lotus Symphony?

For example you mentioned Softonic and they appear to have a Symphony download here.

If the file doesn't open properly in Excel, the code won't do anything to fix that.

In Options > Advanced > Lotus compatibility settings (all the way at the bottom), tick both of those boxes. That may help.

At some point, Excel had the option during installation to include various file conversions, Lotus among them IIRC. It's been long enough since I installed Excel that I don't remember if it still does. You might try to start a reinstall and look for it. (Don't bother to actually do the reinstall if you don't see it.)

I otherwise have no suggestion, sorry.

Perhaps this thread over at MrExcel will help.

Iain

You can run DOS programs using DOSBox - I use it to play old DOS games like Civilisation.

Perhaps you could use it for DOS Symphony?

You can try with OpenOffice / LibreOffice
or
LS4Wv3.32bit

and for the future, here is how you load up VBA. Good that you found the software. Good Luck with the conversion.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

See my last thread for instructions.

Found this link also that may be useful

http://www.ozgrid.com/forum/showthread.php?t=144377

In your last post, it looks like you are missing the last line of code

Please Login or Register  to view this content.

FileSearch has been gone since Excel 2007.

Originally Posted by Snowington

I've been given several 3.5" diskettes (remember them)?

I remember the days before 5 1/4" discs...

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.