Hi Mitrokhin:
On 16/05/08 5:38 PM, in article
160520081008452444%Mitrokhin@[EMAIL PROTECTED]
"Mitrokhin"
<Mitrokhin@[EMAIL PROTECTED]
> wrote:
> Perhaps this is old hat to some but I havn't seen it mentioned in here.
The decision was made about two months ago. Some of us have been under a
non-disclosure agreement that has prevented us talking about it until the
Microsoft announcement appeared.
> I wonder if it's worthwhile to rewrite VBA macros in Applescript,
> (which btw I have been doing for the last couple of days :().
Yes, I think so.
VBA is very good for automation "within" an Application. It begins to
have
problems across applications, and cannot automate non-Microsoft
Applications
at all.
AppleScript's strength is that it can automate ANYTHING on a Macintosh.
Because the AppleScript compiler/runtime runs outside the application, it
is
extremely good at coordinating the efforts of multiple applications.
AppleScript begins to struggle WITHIN an Application, depending on how
richly-implemented the AppleScript Dictionary is.
Because the AppleScript dictionaries in Microsoft Office are simply a
re-expression of the VBA Object Model, and because Microsoft Office's core
applications were designed from the get-go to be automated, AppleScript
provides the ability to automate almost every dot and comma in a Microsoft
Office application.
So now, solution vendors get the ability to choose between two automation
technologies. AppleScript will be the winner when the task involves
automating non-Microsoft applications. VBA will be the winner when the
task
benefits from having common code with the PC version.
> [first Wordbasic then VBA then Applescript then perhaps VBA 2 then ?
> sigh]
The one we REALLY want is "dot-Net". Dot-Net is very difficult to do on
the
Mac, although there are efforts to get it working beginning to appear.
Microsoft's original plans for dot-Net included making it available on
platforms other than Win-Tel.
On a personal note, I am "hoping" (and that's all it is, a "hope") that
"VBA
2" will take us closer to .Net. By the way, I am also hoping that what we
get will be "VBA 7" (the PC Office 2007 version). What we have in Office
2004 is two levels behind that, and the differences are becoming annoying.
Hope this helps
--
Don't wait for your answer, click here: http://www.word.mvps.org/
Please reply in the group. Please do NOT email me unless I ask you to.
John McGhie, Microsoft MVP, Word and Word:Mac
Nhulunbuy, NT, Australia. mailto:john@[EMAIL PROTECTED]
|
