1. Subrat patra
  2. PowerBuilder
  3. Thursday, 1 February 2024 17:24 PM UTC

Hi 

Our client complains that whenever they are trying to export a report in PB application they are getting the application error as attached in the screen shot.

They are getting this error when they are using Microsoft 365 and its working perfectly when they have installed Microsoft 2016.

Can anyone please help .

 

Regards

Subrat

Attachments (1)
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 1 February 2024 19:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi Subrat;

  Can you tell us ...

  1. O/S version & build?
  2. PB version & build?
  3. How is the report being produced (via what mechanism)?

Regards .. Chris

 

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 1 February 2024 20:18 PM UTC
Hi Subrat;

Thank you for those "vitals"!

Yes, OLE could certainly be your "achillis heel" when moving to O365 as Microsoft has tweaked the DOM (Document Object Model) a bit on this newer release (vs say Office 2015 => 2019).

FYI1: https://learn.microsoft.com/en-us/visualstudio/vsto/word-object-model-overview?view=vs-2022&tabs=csharp

FYI2: https://learn.microsoft.com/en-us/visualstudio/vsto/excel-object-model-overview?view=vs-2022&tabs=csharp

So basically, you will probably need to refactor your OLE code a bit in your PB App(s) to traverse the modified DOM in O365.

Tip: You night also want to wrap your PowerScript OLE code in a TRY..CATCH to get more information when an exception is thrown.

HTH

Regards .. Chris
  1. Helpful
  1. Subrat patra
  2. Sunday, 4 February 2024 17:54 PM UTC
Hi Chris,

Thanks for the reply. I am unsure what has changed on the newer version, can you please guide me? I may be missing the important section which has been tweaked.



Regards

Subrat
  1. Helpful
  1. Chris Pollach @Appeon
  2. Sunday, 4 February 2024 21:10 PM UTC
You need to have a look how your current PB based OLE code is working on the previous DOM model & compare that to the new DOM model in O365. Then adjust your App's OLE PowerScript code accordingly.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.