I didn't have any luck transferring macros to MS Works so I suspect "this will never work like this."
OO is likely to be the cheap exit but you could be blunt and just say "this works with Office."
Can this be done?
I don't have MS Works, only MS Office with Excel. I used to have OpenOffice but I uninstalled it. I could re-install it if need be.
I've been developing a spreadsheet for a colleague for his financial accounts on the basis that he has MS Office including Excel installed on his laptop. I asked him specifically, and very carefully, and he assured me he has.
Now, after months of work, he brought his laptop to me and I transferred the xls file to it and tried to open it only to get the "Which program do you want to use" message. It turns out he has MS Works and not MS Office.
He had to leave and take his laptop with him so I couldn't investigate further.
My work is just so much random bits of data if he can't use this. Can this xls file be converted to Works Spreadsheet format? When I look at Excel's save options, I see WKS, but I have a feeling that is Lotus format? Is that right?
I Googled Converting Excel spreadsheets to MS Works Spreadsheet but all I could see was converting MS Works files to Excel readable files. Did I miss anything?
Also back to OpenOffice, it doesn't seem to support Works, but I could get him to download OO and use that, but I fear it means more trials and tribulations. This Excel spreadsheet has a number of VBA macros. I haven't tested this yet on OpenOffice. Is it worth me trying?
Any help would be appreciated, before I kill him!