My VBA fills in six generation pedigrees, and other information. While the simple excell commands work fine, the ones we had to write in VB will not. David Cummings
Andrew Douglas Pitonyak <[EMAIL PROTECTED]> wrote: They would not run because: 1. You must set the security appropriately Use tools > Options > OOo-dev > Security click "Macro Security" Set macro security mode to Medium so that you can at least confirm the macros that you want to enable. 2. Tell OOo to load and enable the macros >From the options (tools > Options) seelct Load/Save > VBA Properties. Check Load Basic code (you can do this for three options) Check Executable code (this option exists only once). You can also check to save the original basic code, i did, but that is not the problem. After this, the VBA scripts are loaded and ready to go. They will still not work, however, because the macro loads a form, and form support does not exist in the VBA support for OOo. Much of the other code, however, will likely work fine (which does not help much since this uses forms). Anthony Chilco wrote: > Hi David, > OOo v3 beta has limited support for VB macros. I opened your > spreadsheet with it, but the macros would not run. > tc > > David Cummings wrote: >> Hi >> >> I have a little Excel program that works on several macros and I want >> to add some more to it. However, I cannot get it to work in Open >> Office Calc. I have been working with this for several years on and >> off and my brother and I finally got the pedigree section to work >> right. However, when I bring over to OP, I cannot get any thing to >> work like I wish. >> >> I am a canary breeder and we who are breeders must keep very accurate >> records. This is important for us though it is just a hobby. Most of >> us do not make any money with our birds, just recover food cost. >> >> Here are the macros. I can attach the sheets if you all wish. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt My Book: http://www.hentzenwerke.com/catalog/oome.htm Info: http://www.pitonyak.org/oo.php See Also: http://documentation.openoffice.org/HOW_TO/index.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
