Hi Jerry,
As long as the macros use plain VB code without any Excel specific functions or
variables, they should run in OOo v3. I haven't had much luck, though. I've
found that the OOo VB implementation will choke on stuff like this:
Dim LastUsedRow As Integer
Dim LastUsedCol As Integer
ActiveCell.SpecialCells(xlLastCell).Select
LastUsedRow = ActiveCell.Row
LastUsedCol = ActiveCell.Column
The assignments to lastused row and col work, but xlLastCell isn't there. I
don't know if there's a method to accomplish this that will work in both packages.
tc
Jerry Feldman wrote:
At work, we have a spreadsheet that serves as a specification for the
C++ product that I am working on. The previous maintainer of the spec
implemented the math as forulae, and was very compatible with OO.o. I
work exclusively on Linux, and I need the spec in OO.o. The new
maintainer of the spec wants to convert this to be macro based (which
is better than the old spec for a number of reasons), but he wants to
maintain it in Excel because he knows VBA, and the spec will be sent
out to other people within the company and to some customers. While we
have agreed that he will also maintain an OO.o document, I was
wondering if there is a good document that compares OO.o basic to VBA.
My premise at work is that the document must be available as an OO.o
document because Excel does not run under Linux.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
