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]
