Re: beginner's Excel script (round2)
Re: beginner's Excel script (round2)
- Subject: Re: beginner's Excel script (round2)
- From: Walter Ian Kaye <email@hidden>
- Date: Sat, 27 Mar 2004 18:48:04 -0800
At 04:21p -0800 03/27/2004, Paul Berkowitz didst inscribe upon an
electronic papyrus:
On 3/27/04 3:40 PM, "Walter Ian Kaye" <email@hidden> wrote:
> Sounds to me like the entire process can be done within Excel using
> one of its native scripting languages (XLM or VBA; your choice). It
> seems rather ridiculous to use an external language when you are
> starting and ending inside Excel.
But AppleScript IS a native language of Excel.
Not the last time I checked... which was 5.0, actually... and AS was
*nothing* but a "VBA puppeteer"; there was nothing "native" about it.
Are you saying the current dictionary bears no resemblance to the 5.0
dictionary? Are you saying the current dictionary is *not* a 1:1 VBA
mapping like 5.0's was? Are you saying it's a true AppleScript object
model, not a VBA model?
It has a large dictionary.
And Whole Foods Market has a large inventory, but very few of their
foods are actually whole (I see white flour and white sugar in many
of them). I should petition the FTC and FDA to force WFM to either
make all foods whole, or change their name. And require any bread
labeled "whole wheat bread" to be 100% whole or to instead be labeled
"wheat bread with whole wheat" to prevent lying.
Not quite complete, and with a few quirks, which need fixing, but if you
know AppleScript and don't know the other lanuages (what's XLM? I never
heard of it) it will do the job.
"XLM" is Microsoft's TLA for "Excel 4.0 Macro" (you know how they love TLAs).
Ctrl-click on a tab, choose Insert, and you can insert a Macro sheet.
XLM (it only got that moniker after 5.0 came out) was my first
computer language; I learned it in 1988 using Excel 1.0, and in 1994
I wrote macros in Excel 4.0 for American Express as part of a program
that was used in 19 countries (I even stuck an easter egg in it: the
About box's OK button would say "Thank you" in the appropriate
language for the country). BTW, if you use Excel much, check out my
Copy Special macro add-in -- it lets you copy/paste cell dimensions,
etc... which cam be quite a timesaver. It's on my Web site.
-Walter
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.