WordApplication (Office) Xplat?

Targets macOS
1

Will the WordApplication (Office) be available for #TargetMacOS anytime soon? I see the current docs say Windows is only supported.

Thanks!

Xojo Docs - WordApplicationt

2

No.

3

How should that work without an implementation of VBA for Microsoft Office on the Mac? Office Automation uses an API provided by Microsoft for their Office products. AFAIK this stuff is not available for Office for Mac, so it won’t be available for Xojo.

4

Thanks Joe and Natascha. I assumed Office for MAC had the same APIs. (Wishful thinking :))

5

I’m using AppleScript to do OfficeAutomation on OSX. I don’t know of any other way to achieve similar results.

6

No SDK any more - not since the PPC days

7

Though VBA is still supported… Word for Mac has a VBA implementation, including custom forms development:

8

Office for Mac 2011 ???

Recall me what today’s date is ?
Ah ! 2014 !!!

Did you check what solution is available with one of the free Office (like LibreOffice) ?

9

[quote=56398:@Emile Schwarz]Office for Mac 2011 ???

Recall me what today’s date is ?
Ah ! 2014 !!!

Did you check what solution is available with one of the free Office (like LibreOffice) ?[/quote]

This is the latest version. I believe some updates to come this year.
No I didn’t check the open source Office clones.

I think that VBA lives only inside the Office apps. Not extendable. Automation from Xojo should be done with Apple Script/Automator.

10

Sorry, I was not crystal clear. I meant any eventual solution within LibreOffice (as an example) and without using Xojo. An internal solution: macro programming capability.

I was not able to found more data on that.

LibreOffice.

11

It appears that it is possible to do some automation with LibreOffice. There is an API accessible from various languages. See here:

This could perhaps be a suitable substitute for MSOffice automation.

12

Isn’t there a plugin for this? I thought you could buy a plugin for cross platform MS office manipulation.

13

LibreOffice for windows you can use Xojo’s OLEObject

See: https://forum.xojo.com/4693-write-an-openoffice-libreoffice-document-with-use-of-xojo-windo

and you will also find some other links related to LibreOffice from above mentioned link

Converting documents with use of LibreOffice see: https://forum.xojo.com/5119-mbs-dynapdf-plugins/p1#p36193

OpenOffice.org Base Macro Programming By Andrew Pitonyak: http://www.pitonyak.org/database/AndrewBase.pdf