Howdy, I'm not having much luck in attempting to get this a Sub Module in an embedded macro to work in this document. This document (attached) was given to me by a professor for an Options & Futures MBA class, to try to visualize option pricing, look at the 'Greeks', etc.. I realize this was intended to be run on a Windows machine, but the code doesn't look too far off from VBA to try to get it working in OO. I'm currently running version 3.1, on Mac 0S 10.5.8.
The first problem, is that I opened the document as .xls, and resaved as .ods. since I hear that might help resolve the #NAME? errors that appear in the document. When I go to Tools->Macros->Organize Macros->OO Basic, and then click the Module 2 macro under OptionTradingWoorkbook2->Standard->Module2 (Edit) I get the following error when I go to try to compile the code:
BASIC Syntax Error
I attempted to verify the VBA code as OO Basic first by using an on-line converter, and there was no difference (verified by the unix diff command). I've never used VBA or macros in Excel, so I'm not sure what the problem here is..
Any pointers, suggestions, etc., on how to make this work would be very helpful, I have a quiz due Tuesday that depends on getting this working. If I can't get it to work here, the next option will be to try to get Parallels working on my mac, but I'd like to see if it's possible to get this working on OO first.
- (93.44 KiB) Downloaded 149 times
OpenOffice 3.1.0 on Mac 10.5.8