Applescript syntax for get international

[Ed Zachary]

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

 

[Paul Berkowitz]

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

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.

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

 

[Ed Zachary]

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.

Paul -

Did you happen to find out anything?

 

[Paul Berkowitz]

Paul -

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

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

 

[Paul Berkowitz]

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

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