* Ennio-Sr <[EMAIL PROTECTED]> [150205, 12:17]:
> * Ian Laurenson <[EMAIL PROTECTED]> [150205, 14:51]:
> > Ennio-Sr wrote:
> > [...]
> >
> > I did a quick google for "Lotus Millennium macros 123" and it appears to
> > be referring to a book.
> > Are you saying that you need more documentation
> > for writing macros in OOo or that the macros that came with the book you
> > require equivalents for Calc?
> > If the latter, say what macros you would
> > require and maybe I and others can write / help you write them.
>
> This is very kind of you. However, as I said above, I have no precise
> idea right now. Generally speaking the .123 feature I would miss much is
> the possibility to write a series of commands on subsequent (vertical)
> cells, give the first cell a single letter 'range' name and be able to
> run the full sequence of commands, any time you want, just pressing ALT
> (or CTRL)+letter.
>
> If time comes that I tackle again the subject I'll remember your offer
> ...
Well, time might have come sooner than expected :-)
I realized I had an OOo copy of a file with macros, originally written
as a .123 file (maybe I migrated it through Excel and/or Gnumeric a few
months ago).
I see that formulas I had in the cells have been translated and seem to
work.
As to macros, you know they work differently on the two programs:
in .123 you define a range (with a single letter or number) for the
first of a vertical group of cells where you put the instructions to be
executed when that range is called (pressing Ctrl+letter). May be these
are not macros, but 'recorded keystrokes sequences' [I cannot check
right now in the original]. I wonder how could I reproduce them in OOo:
should I construct a macro for each of them or there is a quicker way?
As a first example:
{goto}saldar~/c~{down}~ # goto range named 'saldar' and copy it to ..
/rndsaldar~
/wtc{goto}ap1~
This sequence was associated to the Ctrl+0 keystroke and was
automatically executed when the file was opened. Should I repeat all the
steps with the macro-recorder up and then save it as a macro?
Thanks for your attention.
Regards.
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
