Ennio-Sr wrote:
* 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 ;(
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.
What do you mean "cross-reference" a named range?
-- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm Free Info: http://www.pitonyak.org/oo.php
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
