Does anybody know if I can use the Career planner spreadsheet (which I think was created by Eyolfur) in Open Office?
I am particulary asking about the fitness and fatigue planning, as everything else seems to work ok. I can enter the training level for each week with no problems but then when I click on evaluate, it doesn't calculate the new fitness and fatigue values. I think this is to do with the different script languages for writing macros in excel and for writing macros in open office. I really don't know a lot about how macros work though!
Is there a version of the planner out there already which works with Open office? Alternatively, is there a reasonably straightforward way to edit the excel macro to make it work in Open office?
Thanks in advance.
Edited by danny84 on 24-02-2011 14:00
The problem is that eyolfur protected the macros with a password. Therefore it is not possible to see them and/or reprogram them.
But there are trials versions of Excel around.
And maybe you could even make it work in the Excel-Viewer, which is offered free of charge by microsoft.
Actually, it is possible to view and edit the macros within Open Office by going to Tools/Macros/Organize Macros menu. The password must only be effective in excel. However I still have the problem of not knowing what I need to edit. My programming abilities are very basic!
I did come across a converter called 'Convert VBA to OpenOffice Basic' by Business Spreadsheets that can turn visual basic code into open office basic, which I thought might do the trick. But I think it still requires some decent programming knowledge in order to iron out any small mistakes which remain after the conversion.
I'll also look into the excel viewer. I did have a 60 day trial of Microsoft office at some point but obviously it ended a while ago. I presume there is no reason why I couldn't get another trial, but the best solution will be if I can get these macros to work in Open office. Any ideas appreciated!
Thanks.
Edit by admin: The post contained a link to the converter. For some reason, Business Spreadsheets asked for it to be deleted. Since I'm editing this post about a year after it's been posted, I don't see much harm in removing the link. You should be able to find the converter simply by searching for the name of it and the company.
Edited by CrueTrue on 21-09-2012 23:54
