Use AppleScript to get the values of a named range in excel 2004

[Philip Sullivan]

Hi

Does anyone know how to get a the values of a range in excel 2004 into a
list?

I used to use <set value_range to value of range ³what ever the name of the
range is²> in Excel 2001 but it doesn¹t seem to work in Excel 2004

Thanks in anticipation

Philip

 

[JE McGimpsey]

Hi

Does anyone know how to get a the values of a range in excel 2004 into a
list?

I used to use <set value_range to value of range ³what ever the name of the
range is²> in Excel 2001 but it doesn¹t seem to work in Excel 2004

set value_range to value of range "myrange" of activesheet

works for me. What does "doesn't seem to work" mean?

 

[Paul Berkowitz]

set value_range to value of range "myrange" of activesheet

works for me. What does "doesn't seem to work" mean?

The actual saved, compiled script you used to use in 2001 will not work in
2004 - you will get errors about "does not understand «some raw code»" .
That's because the whole Excel AppleScript dictionary was re-done for 2004.
But, as JE says, starting over with the code above and compiling should get
you the result you're looking for.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[Philip Sullivan]

Thanks guys

I've now got it working!

The actual saved, compiled script you used to use in 2001 will not work in
2004 - you will get errors about "does not understand «some raw code»" .
That's because the whole Excel AppleScript dictionary was re-done for 2004.
But, as JE says, starting over with the code above and compiling should get
you the result you're looking for.