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

Resolved Ole automation with office 'Click to Run' install

  1. Issue
0
Votes
Undo
  1. BRIAN PROM
    BRIAN PROM
  2. PowerBuilder
  3. Wednesday, 6 March 2019 21:16 PM UTC

We have a customer who has office 365 'click to run' installed version (vs full msi install).  They are not able to connect to excel using the ConnectToNewObject method call.  Excel is loaded, just it's the 'click to run' version.  Is it possible to trick Powerbuilder into thinking excel is installed?  

Thanks,
Brian Prom

DataWindow not retrieving date column
TX Control - how to access native methods and prop...
Accepted Answer
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 7 March 2019 00:10 AM UTC
  2. PowerBuilder
  3. # Permalink

The whole point of Click To Run is to run the program in isolation for security purposes. A side effect that Microsoft failed to address is OLE Automation doesn't work.

If they really need the PB app to control Excel, they will have to switch to a regular install on the PC that will use that feature.

Comment
There are no comments made yet.
Responses (4)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 6 March 2019 21:32 PM UTC
  2. PowerBuilder
  3. # 1

https://answers.microsoft.com/en-us/office/forum/office_2016-office_install/office-click-ro-run-and-ole-automation/abc2fe0d-58e4-42eb-84ef-a6e7c1c7b3f4

 

Comment
There are no comments made yet.
BRIAN PROM
BRIAN PROM Accepted Answer Pending Moderation
  1. Wednesday, 6 March 2019 21:37 PM UTC
  2. PowerBuilder
  3. # 2

Hi Roland,

I did see that post and I did run these two commands on that server.  They said they ran successfully, but it didn't fix the ole automation issue. 

C:\Windows\Microsoft.NET\Framework\v4.0.30319>regtlibv12.exe "C:\Program Files (x86)\Common Files\Microsoft Shared\Office16\MSO.DLL"

C:\Windows\Microsoft.NET\Framework\v4.0.30319>regtlibv12.exe "C:\Program Files (x86)\Microsoft Office\Office16\MSWORD.OLB"

Thanks,

Brian

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 6 March 2019 22:27 PM UTC
  2. PowerBuilder
  3. # 3

Brian -

   If the two commands in the post from Roland worked, then what's the "ole automation issue" the customer has?


Later -

Olan

Comment
BRIAN PROM
  1. BRIAN PROM
  2. Wednesday, 6 March 2019 22:51 PM UTC
Hi, The commands ran successfully, but it did not fix the 'ole automation issue'



Thanks,

Brian
  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.