Office class doesn't exists...

I’m trying to use the MSOfficeAutomation plugin but I run in an error saying “Item does not exists”. I copied the plugin from the extra folder to the XOJO plugin folder and restarted.

OLE works fine. I can create or open a word document, send text to it… I need to refer to some of the Office Class to move through the lines and paragraphs…

The code

Dim v As Variant
v = Office....

will trigger the autocompletion tool where all Office Class members are tagged with yellow warnings

Any idea about what’s wrong?

Xojo 2014 R1.1, Office 2013, VBA installed.

Thanks!

I just found out that the Office Class can’t be used in Web Applications.

Possible option: have your web app spawn a desktop helper app and communicate with it via sockets (IPC or TCP). Your web app could instruct your desktop helper to create/modify Office docs.

Thank you!

Could you give me some clues on how to do that?

Thanks again!

[quote=88067:@Roger St-Arneault]Thank you!

Could you give me some clues on how to do that?

Thanks again![/quote]
Quite the large topic and I was in the same spot as you were not too long ago. This helped me greatly.

http://documentation.xojo.com/index.php/IPCSocket

http://documentation.xojo.com/index.php/TCPSocket

I’m on it!