Applescript syntax for get international

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed Zachary - 05 Jan 2006 20:02 GMT

For Excel 2004, what is the syntax to obtain an entry from "get
international"? The dictionary entry is a bit confusing and the
various permutations I've tried don't compile or fail at runtime. E.g.
this fails at runtime:

tell application "Microsoft Excel"
set foo to get international country_setting
end tell

(Also I note that the Excel2004AppleScriptRef.pdf says that 'get
international' is not currently supported, but I presume since it's
present in the dictionary that it is supported.)

Reply to this Message

Paul Berkowitz - 05 Jan 2006 21:23 GMT

On 1/5/06 12:02 PM, in article
1136491353.347677.11440@o13g2000cwo.googlegroups.com, "Ed Zachary"
<jlmarr@mac.com> wrote:

> For Excel 2004, what is the syntax to obtain an entry from "get
> international"? The dictionary entry is a bit confusing and the
[quoted text clipped - 8 lines]
> international' is not currently supported, but I presume since it's
> present in the dictionary that it is supported.)

No, the Reference means what it says. It probably _shouldn't_ appear in the
dictionary, but I guess they have the "hooks" set up. That's why it compiled
but doesn't run. The Reference (which is just a PDF and therefore can be
revised between major upgrades, which is usually the only time AppleScript
gets updated in the app itself) is generally more up to date and reliable
than the dictionary. It was revised a few months after 2004 came out.

In VBA, Application.International(xlCountrySetting) works fine. So it ought
to be possible to enter that much (and/or more) in a macro, and then call it
via 'run VB macro' from AppleScript if you need to do it in AppleScript. But
I can't get that to work either. I'm going to inquire why not.

Signature

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.

Reply to this Message

Ed Zachary - 31 Jan 2006 03:12 GMT

> > (Also I note that the Excel2004AppleScriptRef.pdf says that 'get
> > international' is not currently supported, but I presume since it's
[quoted text clipped - 11 lines]
> via 'run VB macro' from AppleScript if you need to do it in AppleScript. But
> I can't get that to work either. I'm going to inquire why not.

Paul -

Did you happen to find out anything?

Reply to this Message

Paul Berkowitz - 31 Jan 2006 07:05 GMT

On 1/30/06 7:12 PM, in article
1138677126.743287.86420@g47g2000cwa.googlegroups.com, "Ed Zachary"
<jlmarr@mac.com> wrote:

>>> (Also I note that the Excel2004AppleScriptRef.pdf says that 'get
>>> international' is not currently supported, but I presume since it's
[quoted text clipped - 15 lines]
>
> Did you happen to find out anything?

I've been told it's been referred to the Excel AppleScript expert but he/she
has not replied as yet...

Signature

Reply to this Message

Paul Berkowitz - 31 Jan 2006 21:18 GMT

On 1/30/06 11:05 PM, in article C0044C26.C0FA2%berkowit@spoof_silcom.com,

>>>> (Also I note that the Excel2004AppleScriptRef.pdf says that 'get
>>>> international' is not currently supported, but I presume since it's
[quoted text clipped - 18 lines]
> I've been told it's been referred to the Excel AppleScript expert but he/she
> has not replied as yet...

OK, nagged them and got a reply. It is confirmed as a bug, and it is due to
be fixed in a later release. (No idea whether that means a service release
to Excel 2004 or the next major release of Office, whenever that might be.
We'll have to wait and see. Even if I did know, I wouldn't be able to tell
you, but I honestly don't know.)

Signature

Reply to this Message

Mac Forum / Applications / Excel / January 2006

Applescript syntax for get international