Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved OLE Activate PowerBuilder Error R0039

  1. How-to
0
Votes
Undo
  1. Sufyan Maghur
    Sufyan Maghur
  2. PowerBuilder
  3. Monday, 17 July 2023 17:17 PM UTC

Using PowerBuilder 2019

We are trying to access a Microsoft Excel file (OLE Object) in a datawidow

li_rc = ldw.object.ole_1.activate(OffSite!) // activate OLE

But are getting an error of Unknown Object

Is this Ghostscript security flaw something Appeon...
WebBrowser Control - What event fires when a file ...
Responses (3)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 18 July 2023 03:56 AM UTC
  2. PowerBuilder
  3. # 1

Hi,

I think that John is right. First of all: The link provided by Chris, is about Outlook. Microsoft has NOT removed OLE in Office365, it's just not present in their "New Outlook" (AKA "Monarch), which has nothing to do with Office 365, but is some kind of app similar to their Outlook web.

You are using an Excel ole object, so that has nothing to do with Outlook. What I've experienced with visual Office OLE control's which you can insert by choosing them from the list of OLE objects,  is that they are heavily outdated since many versions of powerbuilder.

I assume that the same goes for the ones that you can paste on a datawindow.

regards.

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 18 July 2023 13:44 PM UTC
Hi Miguel;

I wonder if there was either an MS-Windows and / or MS-Office update that messed up the registry at one point and then another MS update that fixed that error?

Regards ... Chris
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 18 July 2023 14:11 PM UTC
@John: maybe I'm blind, but I still don't know "how it was done".

@Chris:I don't know as I still don't know what "the issue" was. The syntax that Sufyan shows in a comment above, is the same as the one he originally states in the question. Only he/she knows.

regards.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 18 July 2023 14:14 PM UTC
@Chris. Could very well be a registry problem. In the past we've had many problems with "Virtual Store" folders in the registry.
  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Monday, 17 July 2023 18:35 PM UTC
  2. PowerBuilder
  3. # 2

Hi, Sufyan - 

I think your syntax is in error. What you have coded looks to be a method/function call, and DataWindow object dot notation is used to reference properties.

Look up the PB Help topic named "Activation property (DataWindow object)" for the proper syntax.

Best regards, John

Comment
Sufyan Maghur
  1. Sufyan Maghur
  2. Monday, 17 July 2023 20:36 PM UTC
It was an Office 365 issue as Chris had indicated below... Thank you
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 17 July 2023 18:10 PM UTC
  2. PowerBuilder
  3. # 3

Hi Sufyan;

  If you're using the latest Office 365 - it looks like Microsoft may have removed the OLE feature....

https://community.appeon.com/index.php/qna/q-a/ole-connection-to-ms-outlook

Regards ... Chris 

Comment
Sufyan Maghur
  1. Sufyan Maghur
  2. Monday, 17 July 2023 20:36 PM UTC
Thank You Chris that was helpful
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 17 July 2023 21:01 PM UTC
You are most welcome Sufyan.
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.