Hi David,
This may help:
http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf
tc
David Cummings wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
