Thank you for the replies so far, just wish we could get somewhere. Do any of you know of a site where I could get the VB command=OO command? If I could get that, I could then translate the program with just a bit of work.
On the pedigree section of the program not even Microsoft professional were able to help. We just experimented until we finally got the right combo. David Cummings -----Original Message----- From: Anthony Chilco [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2008 1:14 PM To: [email protected] Subject: Re: [users] macros help 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. > > David Cummings > > Sub DataEntryForm1() > > ' > > ' DataEntryForm1 Macro > > ' Macro recorded 11/23/2002 by Unknown User > > ' > > ' > > Sheets("BirdData").Select > > Range("A1").Select > > ActiveSheet.ShowDataForm > > Sheets("Tree").Select > > Range("A1").Select > > End Sub > > Sub BuildTreeForm2() > > ' > > ' BuildTreeForm2 Macro > > ' Macro recorded 11/23/2002 by Unknown User > > Sheets("BirdData").Select > > Range("A1").Select > > frmBuildTree.Show > > Sheets("Tree").Select > > Range("A1").Select > > End Sub > > Sub PrintTree() > > Sheets("Tree").Select > > Range("B1").Select > > ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True > > Range("B1").Select > > End Sub > > Suspicious files found in the attachments > Bird Record Book.xls: Contains macros > > Checked by AVG - http://www.avg.com > Version: 8.0.138 / Virus Database: 270.6.3/1613 - Release Date: 8/15/2008 5:58 AM > > > ------------------------------------------------------------------------ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
