Re: Is it possible to interact with Microsoft Office X programmatically
Re: Is it possible to interact with Microsoft Office X programmatically
- Subject: Re: Is it possible to interact with Microsoft Office X programmatically
- From: Ed Watkeys <email@hidden>
- Date: Thu, 27 Nov 2003 09:28:53 -0500
On Nov 26, 2003, at 6:34 PM, Fei Li wrote:
Hello all,
I hope I can save some changes programmatically into PowerPoint file
when user is doing the presentation, and refresh it immediately. Or
save changes programmatically in Microsoft Word, Excel. Is it possible
to do that?
Apple provides APIs, file format specifications, and other resources
to provide developers to interact with various Apple applications.
Where can I find these kind of information for Microsoft applications.
Thanks in advance for any information!
Fei
Microsoft is, alas, a Microsoft shop, so they prefer, err require, that
you to use Visual Basic for Applications. The Office applications
support a single AppleEvent in addition to the required four: (from the
PowerPoint AppleScript dictionary)
do Visual Basic: Execute a Visual Basic script
do Visual Basic string -- The script to execute
[Result: anything] -- the result of the script
My guess is that you need to use the Visual Basic Editor to create
macros that do what you want to accomplish, and then invoke them via
"do Visual Basic". This means that you'll need to "install" those
macros somehow before calling them. The online documentation in Office
should get you started; look under Power Features > Macros.
Good luck,
Ed
_______________________________________________
cocoa-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.