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