On Fri, 2005-02-18 at 21:24 -0500, Anthony Chilco wrote: > Hi John, > The short answer is: yes, Open Office calc has macro capability. The > transition from excel macros though, is not simple. The macros use > basic, but the interface to the spreadsheet is completely different. If > you have only one macro, you may be able to translate it.
See http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf for the cross reference to help you translate. THere is also a zipfile of examples. > Calc has a > macro recording facility, but the results are quite wordy. There is lots > of help available here and one the [email protected] list. A good start > is a collection macro examples with explanations that's maintained by > one of the volunteers on the list. > > Get 'How to use basic macros.sxw' (on the OOo docs page) This is in the HOW_TO section: http://documentation.openoffice.org/HOW_TO/various_topics/How_to_use_basic_macros.sxw > and Andrew P.'s > macro examples document. They'll give you more than enough to get started > with. > http://www.pitonyak.org/AndrewMacro.sxw > > John Connett wrote: > > >Hi > >I am looking for a spreadsheet which will run under Windows XP and which has > >a macro capability. I am at present using Microsoft Excel for Windows 95 on > >Windows 98SE, and I should prefer to be able to transfer my existing macro > >to the new spreadsheet. However, if that is not possible, I should be > >prepared to write a new one, provided sufficient instructions were provided. > >(The present one is written in Visual Basic). Do you consider the > >spreadsheet in Open Office would fill the bill? > >John Connett > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Documentation Co-Lead PLEASE - keep list traffic on the list. Email sent directly to me may be ignored utterly. "Dinna meddle wi' things ye ken nuthin' aboot!" J.Herriot --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
