Re: Word scripting?
Re: Word scripting?
- Subject: Re: Word scripting?
- From: David Wignall <email@hidden>
- Date: Tue, 25 Mar 2003 21:59:30 +1200
on 25/3/2003 8:01 PM, Paul Berkowitz at email@hidden wrote:
>
On 3/24/03 11:49 PM, "David Wignall" <email@hidden> wrote:
>
>
> on 25/3/2003 7:22 AM, Dave Groover at email@hidden wrote:
>
>
>
>> But if Word needs a whole other language then I will definitely
>
>> rethink using it as my letter program of choice. I would still want
>
>> to translate into word as most others on the planet, in the business
>
>> world, use MS Word files.
>
>
>
> Something else to think about is that a VBA procedure only exists with an
>
> instance of the application in question, Word in this case. So if you want
>
> something that a user can start independently of Word then AppleScript is
>
> the way to go.
>
>
But I never said to use a VBA macro in a Word document or template. I said
>
he could use 'do Visual Basic' in AppleScript. That can be started from
>
anyway - a self-standing applet, the OS Scripts menu, another application's
>
script menu, anywhere. In a way, that's the whole point of 'do Visual basic'
>
- otherwise, since you've gone to the trouble to learn VBA, you might just
>
as well make it a macro. 'do Visual Basic' allows you to call Word from
>
elsewhere.
Um, if you can write the string for 'do Visual Basic' then you know enough
to make a macro, but yeah, fair enough.
Thinking it through a little more slowly: my approach is that I can pass
variables from the AppleScript part to the 'do Visual Basic' well enough, as
long as I keep track of the plethora of quote marks that ensue, but I've
never had much success going the other way. Along the same lines you can't,
AFAIK, create a VBA function via AppleScript. So, for these and similar
reasons, I've always worked entirely in VBA. However if this was all to be
in a template then you could simply script the creation of a new document
based on that template and let Document_new or AutoNew direct things from
that point on.
--
Dave
"Perhaps the truth is less interesting than the facts?"
Amy Weiss,
The RIAA's Senior Vice President of Communications
Email to The Register
_______________________________________________
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.