* G. Roderick Singleton <[EMAIL PROTECTED]> [280205, 18:06]:
> On Mon, 2005-02-28 at 22:54 +0100, Ennio-Sr wrote:
> > Hi all!
> > In my efforts to migrate from Lotus to OOo I came over a new obstacle:
> >
> > I'm unable to set up a macro equivalent to:
> >
> > {goto}AT125~O~/fcansalx~{esc}{esc}c:\path\cc_fam\cc_x~
> >
> > that more or less means:
> > got to cell at125 of this s.s., then open s.s. "cc_x", copy range named
> > "salx" from it and paste it to said cell in this s.s.
> >
> > I tried to use the Macro Recorder to get some guidance, but it complains
> > about macro from another s.s. being not available ;(
> > Searched FAQs, past posts, Guides ... nope ;(
> >
> > Could any of you give some suggestion?
> > TIA,
> > Ennio.
> >
> >
>
> Ennio,
>
> I think you can do this without such a fancy mechanism. On page 196 of
> the user guide there is this heading:
>
> Referencing a Cell in Another Document
> Cells can also be referenced in other spreadsheets:
>
> I think this is what you want without the aggravation of having to write
> a macro.
Thank you, GRS, for this indication: it's a very enlightnening reading
(I'd skipped that while looking at the index: it' extraordinary how many
things a name can hide ... ;( ).
At this point I'm sure a closer answer to my need is hidden somewhere:
How can I cross-reference a named range?
[I was unable to do that even in the same spreadsheet: maybe I'm too
asleep now ... :) ]
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]
