Recent

Author Topic: OLE automation and Office 365  (Read 6973 times)

bigeno

  • Sr. Member
  • ****
  • Posts: 266
OLE automation and Office 365
« on: April 07, 2018, 06:57:30 pm »
Can someone help me with information about Office 365 ?
I'm using OLE to transfer data from my app to Excel/Word, all works ok but I get some information that my app don't work in Office 365.
I can't test now (don't have 365), the app can't start GetActiveOleObject('Excel.Application').
Does Office 365 have full working OLE automation ?

Phil

  • Hero Member
  • *****
  • Posts: 2737
Re: OLE automation and Office 365
« Reply #1 on: April 07, 2018, 07:12:15 pm »
Can someone help me with information about Office 365 ?
I'm using OLE to transfer data from my app to Excel/Word, all works ok but I get some information that my app don't work in Office 365.
I can't test now (don't have 365), the app can't start GetActiveOleObject('Excel.Application').
Does Office 365 have full working OLE automation ?

Office 365 is just the subscription. You still run the same Office apps.

Your app may have a problem with an Office app, but I don't think it has anything to do with the subscription.

You need to test it yourself.

I do know that Office apps on Mac are completely scriptable.

bigeno

  • Sr. Member
  • ****
  • Posts: 266
Re: OLE automation and Office 365
« Reply #2 on: April 07, 2018, 07:52:33 pm »
Yup, one month subscription not big deal, just testing and all works good here...

Phil

  • Hero Member
  • *****
  • Posts: 2737
Re: OLE automation and Office 365
« Reply #3 on: April 07, 2018, 07:55:18 pm »
Yup, one month subscription not big deal, just testing and all works good here...

Sounds good.

In case you're interested in supporting Mac with Office apps someday:

https://macpgmr.github.io/ObjP/MacAutomationWithPascal.html

I've scripted Excel from a Mac app to do charting - works good.

bigeno

  • Sr. Member
  • ****
  • Posts: 266
Re: OLE automation and Office 365
« Reply #4 on: April 07, 2018, 08:04:02 pm »
Sounds good.

In case you're interested in supporting Mac with Office apps someday:

https://macpgmr.github.io/ObjP/MacAutomationWithPascal.html

I've scripted Excel from a Mac app to do charting - works good.

oops, I write app as shortcut application  :(, Im on Windows

Pees290

  • Newbie
  • Posts: 1
Re: OLE automation and Office 365
« Reply #5 on: September 23, 2020, 01:39:33 pm »
Hi all,

Since I have similar problem I am refreshing the thread.
My app is working in hundreds of places, and it uses automation to make reports in MS Excel.
My client decided to use Office 365, and automation does not work anymore.
As I understood, they use online version of Excel.
Is there any way to make it work ?

PascalDragon

  • Hero Member
  • *****
  • Posts: 5446
  • Compiler Developer
Re: OLE automation and Office 365
« Reply #6 on: September 23, 2020, 03:45:28 pm »
As I understood, they use online version of Excel.

For the online version you'll have to use their Web API (if they provide any). We do at least have some support in the direction of Office 365, though you'll probably have to implement the Excel specific stuff yourself.

winni

  • Hero Member
  • *****
  • Posts: 3197
Re: OLE automation and Office 365
« Reply #7 on: September 23, 2020, 05:48:31 pm »
Hi!

Just for your information:

In germany Office 365 is forbidden for the use in govermental bureaus due to
data privacy protection.

Winni

jamie

  • Hero Member
  • *****
  • Posts: 6090
Re: OLE automation and Office 365
« Reply #8 on: September 23, 2020, 07:56:57 pm »
I guess lesson learned.
Don't depend on optional software that is not yours to make yours work.

I learned that years ago after getting a pdf creator package only to find it required ms office to use it.
 I don't have that in most of my pc's
The only true wisdom is knowing you know nothing

winni

  • Hero Member
  • *****
  • Posts: 3197
Re: OLE automation and Office 365
« Reply #9 on: September 23, 2020, 08:29:06 pm »
Hi all,

Since I have similar problem I am refreshing the thread.
My app is working in hundreds of places, and it uses automation to make reports in MS Excel.
My client decided to use Office 365, and automation does not work anymore.
As I understood, they use online version of Excel.
Is there any way to make it work ?

Tell them to use LibreOffice Calc.
And to give you the money they saved.

Winni

Thaddy

  • Hero Member
  • *****
  • Posts: 14204
  • Probably until I exterminate Putin.
Re: OLE automation and Office 365
« Reply #10 on: September 23, 2020, 08:40:37 pm »
Does Office 365 have full working OLE automation ?
No
Specialize a type, not a var.

egsuh

  • Hero Member
  • *****
  • Posts: 1273
Re: OLE automation and Office 365
« Reply #11 on: September 24, 2020, 09:54:19 am »
It's strange. Office 365 is not a separate program. It's just licensing --- subscription.
I did some test (just a small amount), and OLE works fine. I'm using Office 365.

Also I tried OpenOffice.org. It's good. I can make a text document within Pascal program.

PascalDragon

  • Hero Member
  • *****
  • Posts: 5446
  • Compiler Developer
Re: OLE automation and Office 365
« Reply #12 on: September 24, 2020, 02:00:30 pm »
It's strange. Office 365 is not a separate program. It's just licensing --- subscription.
I did some test (just a small amount), and OLE works fine. I'm using Office 365.

The question is about the cloud based variant of Office.

Thaddy

  • Hero Member
  • *****
  • Posts: 14204
  • Probably until I exterminate Putin.
Re: OLE automation and Office 365
« Reply #13 on: September 24, 2020, 02:12:40 pm »
Indeed. That is how I interpreted it.
Specialize a type, not a var.

 

TinyPortal © 2005-2018