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.
--
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]