Using "do Visual Basic" from AppleScript to access Office 2004

I am trying to automate word,excel and ppt via
Java-Cocoa-AppleScript-VB.  The Java application exists already.  The
objective here is to have the *same* interface access all three apps
.... this seems impossible given the inconsistent level of method
exposure MS have provided.

Using all AppleScript fails because PPT has a very limited set of
objects that can be accessed from AS.  For this reason I decided to
investigate using VB to do the work (yes, even though the mechanism to
return values is broken) and use the 'do Visual Basic' command to send
it to the app.

It does not look like Excel supports the 'do Visual Basic' command.
The file *cannot* contain a macro so the VB code needs to be sent from
AS.

Have I hit another wall here?  It would bite to have *two* interfaces
just because MS could not be consistent.

0
xfourten (3)
5/5/2005 3:02:18 PM
mac.office 7017 articles. 0 followers. Follow

0 Replies
344 Views

Similar Articles

[PageSpeed] 3

Reply:

Similar Artilces:

Using "do Visual Basic" from AppleScript to access Office 2004
I am trying to automate word,excel and ppt via Java-Cocoa-AppleScript-VB. The Java application exists already. The objective here is to have the *same* interface access all three apps .... this seems impossible given the inconsistent level of method exposure MS have provided. Using all AppleScript fails because PPT has a very limited set of objects that can be accessed from AS. For this reason I decided to investigate using VB to do the work (yes, even though the mechanism to return values is broken) and use the 'do Visual Basic' command to send it to the app. It does not look lik...