Re: Excel 11.0
Re: Excel 11.0
- Subject: Re: Excel 11.0
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 27 Oct 2005 01:54:46 -0700
- Thread-topic: Excel 11.0
On 10/27/05 1:39 AM, "Olivier Berquin" <email@hidden> wrote:
>
> I've a script for Excel 10 wich use this line:
>
>
> set x to Formula of Selection
>
>
> I would like to have the same command for Excel 11.
Do you really and truly want the formula - is there really a formula?
Sometimes people used 'Formula' when all they wanted was the actual content
of a cell. If that's what you want, do
set x to value of selection
That will work even if you select many cells - you'll get a list of lists of
values, which could be text, numbers, dates. (The inner lists represent the
row(s).)
Actually
set x to formula of selection
will work too, even when there are no formulas, to get the same content. Did
you not try it? Your capitalized version will recompile to lower case.
I expect what you did was to open a compiled script written for X with 2004
open, and saw all the «raw codes» that now don't work, right? If you quit
Script Editor and Excel 2004, and open Excel X then Script Editor, then open
your old scripts and save a copy As Text, then quit SE again and Excel X,
open 2004, re-launch Script Editor and open the text copy, you'll find it
quite easy to change the text to the new terminology (which is often very
close to the old terminology, but lower-case and separate words) without any
of those baffling «raw codes» in your way.
--
Paul Berkowitz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
| References: | |
| | >Excel 11.0 (From: Olivier Berquin <email@hidden>) |