2008/8/15 David Cummings <[EMAIL PROTECTED]>
> 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
>
>
>
As far as I know, OpenOffice.org can not use Visual Basic for Application
macros, at least not by default. I think that OpenOffice.org 3.0 can, or at
least convert to OpenOffice.org Basic. I also think that there is some kind
of extension somewhere do install to make OpenOffice.org able to run or
convert such macros. Maybe someone else know where to find what you need, I
don't since I never needed it myself.
J.R.
