Weight Loss Xls

The hackers diet, excel vs openoffice with macro’s?

I wanted to check out the ms excel files that the hackers diet has to help monitor weight loss progress and the macro is not working. Now it looks like these files are ment for a older version of excel (97?), I guess I’m not sure why it isn’t working. Here is the website for the hackers diet e-book, and a there-in you are able to find a link to the computer tools:

http://www.fourmilab.ch/hackdiet/e4/

According to the text found in “Weight Monitoring” when the you open the file “WEIGTEMP.XLS ” a new weight menu should appear on the right of the standard excel menu’s. Where it’s open office perhaps the programing is screwy.

FYI: Openoffice did see the macro, I changed the security settings to allow it to load. It didn’t seem like it did anything…

I’m running the latest version of openoffice (3.0) Any help would be appreciated.

Microsoft Office uses Visual Basic for Applications as its macro language,

OpenOffice.org uses OpenOffice Basic, or Python or Beanshell or JavaScript. It does not use Microsoft’s Visual Basic for Applications. Accordingly macros that work on Microsoft Office can be loaded into OpenOffice.org and saved there, but they will not run on OpenOffice.org.

Similarly OpenOffice.org macros will not run under Microsoft Office.

You might try OxygenOffice Professional from http://www.download.com/OxygenOffice-Professional/3000-2064_4-10758848.html . This is a legitimate fork of OpenOffice.org and claims that Microsoft Office macros for Excel will work with Calc under it. Because it is a fork of OpenOffice.org, it will ask that you uninstall OpenOffice.org before installing OxygenOffice Professional.

It is entirely free, like OpenOffice.org. I had a version OxygenOffice Professional on my machine for a while, and it worked identically. I only put OpenOffice.org back because I wanted exact compatiblity with the machines at work for testing purposes.

Another answer is to look at the macro and rewrite it for OpenOffice.org, if you have sufficient programming skills.

The suggestion to download the free Microsoft Office viewers should also work.