On Sun, 25 May 2008 09:03:33 +0300 "Dotan Cohen" <[EMAIL PROTECTED]> wrote:
> 2008/5/24 Jerry Feldman <[EMAIL PROTECTED]>:
> > Here is a macro that I hard coded to increment a value in cell D2. I
> > must admit that I found something similar online, but I need to start
> > to learn OO.o macro languages in the next few weeks.
> >
> > Sub Incd2()
> > mynum = Range("d2") + 1
> > Range("d2") = mynum
> > End Sub
> >
>
> Thank you Jerry. I am having a hard time getting macros to run, I
> think that there is a problem with my java installation. In any case,
> I thank you for your work.
>
> As I have 3*50 cells that need to be updated in this fashion, I have
> been trying to figure out a non-hard coded solution. Ideally, I would
> simply click the cell to have it's value incremented, however, I do
> not see a onMouseClick type of condition for the cell functions.
WRT: Java. I also got a message. All I did was to go to
Tools/Options/OpenOffice.org/Java, and point it at your installed JRE.
I run SuSE 10.3, and I pointed it
to /usr/lib/jvm/java-1.6.0.u6-sun-1.6.0.u6/jre
There are a number of web sites that have Excel macro tutorials. Try
some of the techniques here.
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
While not all Excel functions and techniques work in OO.o (and
conversely not all OO.o techniques work in Excel), much of what you
want to do should be available in one of the online tutorials. There
are also some books. You'll find that the above macro looks like on in
Julian's page, but another macro that I need that tells me the last row
I grabbed from somewhere else.
--
--
Jerry Feldman <[EMAIL PROTECTED]>
Boston Linux and Unix
PGP key id: 537C5846
PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
