Discussions tagged OLE
Calling .NET Components from PowerBuilder Via COM Wrappers...
- Resolved
- New
- How-to
- Last updated 4 days ago
- Bruce Armstrong replied 2 days ago
...without using the Microsoft Interop Forms Toolkit.
What we do until now: We use the .NET Framework 4.8.1 to write class libraries in C# and expose them to COM using the Interop Forms Toolkit. We call the COM-Server from PowerBuilder 2021. This wo...
How to show and refresh Excel spreadsheet in the PB App without Excel becoming visible
- New
- How-to
- Last updated 5 days ago
Hi,
I have placed an Excel spreadsheet into PB window as an OLE Control. The spreadsheets get the data from PowerQuery, retrieving data from an Oracle database, and there is a simple dashboard on the spreadsheet using the data retrieved.
What I wou...
Opening a word document inside ole control
- How-to
- Last updated 1 month ago
- Miguel Leeuwe replied 1 month ago
Hello,I want to open a MS Word document within an OLE control inside a PowerBuilder window. In earlier versions of Word, the document opened inside the window (this is the desired behaviour). In newer versions it opens outside the window.
I have t...
How to add CC to Outlook message (using OLE)
- How-to
- Last updated 1 month ago
- Miguel Leeuwe replied 1 month ago
Hi,
I'm trying to add CC address to an email I send from PB.
Settting the subject, To (single receiver) work fine, but trying to add the CC gives error "incorrect number of parameters".
here is an extract of the code
// This part works finelol...
Hello All,
I've had a strange error crop up in the last couple months on an app deployed and in use for many year without issue. My hunch is that it relates to a windows update security change or something else in the users security environment. ...
I'm using PB2021 Build 1509.
I wish to view PDF files in a window (does not necessarily need to be a datawindow).
Can anyone provide me sample code for me to look at?
I have had limited success using an ole object inserting "Adobe Acrobat Browser ...
Hi,
I have created an application for a customer, that sends email through users Outlook. It has worked without problems for years.
For some time ago we switched the distribution of the application into Cloud App launcher model. Works fine.
Now we...
Problem with OLE Control (microsoft word document)
- How-to
- Last updated 9 months ago
- Michael Gerus replied 8 months ago
Hi, friends.
Please, help. I use OLE control (microsoft word document) in a window of PowerBuilder application.
All worked correct. But suddenly Word began to open as regular application and not in OLE control after upgrade of Office on some comput...
Hi all,
I'm trying to print to a Brother label printer from my PB App. Everything is fine until I execute iDoc.PrintOut() function (iDoc is the OLEObject). The function keeps returning the same error (Error 11 - Printer not supported). But I can ...
How to upload and edit word template in powerbuilder
- How-to
- Last updated 10 months ago
- Miguel Leeuwe replied 10 months ago
Hi Team,
Greeting for the day,
Requesting to kindly help me to know how to upload and edit the word template in PowerBuilder ( OLE ).
I have multiple templates and want to upload on basis of condition.
Need to edit the template and print the same...
The window is getting freeze which is having the MS-office(we are using O365 version) control attached on that window via OLE control. When we open that window, while initializing the WORD component, it is getting freeze for sometime. And because of...
Seeking suggestion for third-party Office ActiveX/OCX
- Advice
- Last updated 12 months ago
- Aron Cox replied 11 months ago
The window is getting freeze which is having the MS-office(we are using O365 version) control attached on that window via OLE control. When we open that window, while initializing the WORD component, it is getting freeze for sometime. And because of...
Add OLE 64-bits Components from PowerBuilder IDE
- Misc
- Last updated 1 year ago
- Armeen Mazda @Appeon replied 1 year ago
It would be great that you implement that the PowerBuilder IDE can add 64-bit OLE objects, currently I have a project that I must use 64-bit components and currently I can't use them.
Thanks in adavance...
ConnectToNewObject(Powerbuilder.Application) customers missing a dll?
- Resolved
- How-to
- Last updated 1 year ago
- Brage Mogstad replied 1 year ago
Hello,This works on my workstation where PB is installed.With customers, it does not work (exe+pbd+dll).Am I missing .dll's in my deployment?
oleObject PBObjectlong ll_result
PBObject = CREATE oleObject
ll_result = PBObject.ConnectToNewObject &am...
Excel, OLE, Error in Copying multiple sheets into an excel. Wrong sheet was copied.
- Issue
- Last updated 1 year ago
- John Fauss replied 1 year ago
Hi All,
My program is generating reports in excel format which contains 8 sheets. It is batch program to pick up the request from the queue, generate the reports, and send them to the user. And 4 sessions are running at the same time to process the ...
Hello,
I have a PowerBuilder function which returns an array of members of an ActiveDirectory group. This works fine on my dev PC. However, when deployed it runs fine on some PCs but does not work on some others. I am unable to get to rootDSE when i...
Handling events fired by OLE object
- How-to
- Last updated 1 year ago
- Konstantin Goldobin replied 1 year ago
Hello,
I was wondering if there is way of hooking up my handlers for events fired by an external (nonvisual) OLE object. That is, after I create an OLEObject and connect using ConnectToNewObject, I'd like to be able to write a script (an event or fu...
I'm attempting to use the LoadXml() method of an MSXML Dom Document in an azure environment and it simply isn't working. When running on non-azure environments it works fine.There is no dev environment for our azure server yet so I can't view the err...
How call VBA macros und functions written yourself?
- Resolved
- How-to
- Last updated 1 year ago
- Konrad Kaltenbach replied 1 year ago
Dear Experts,
I want to call VisualBasic for Application (VBA) macros and functions in Word or Excel documents which I have written myself out of/from PowerScript functions (instead of rewritting them in the PowerScript functions).
Is this possible...
OLE Connecting to Libre Office Writer
- Resolved
- How-to
- Last updated 1 year ago
- David Lacey replied 1 year ago
Hi All,
I have successfully been using this script to connect to MS word
iole_object.ConnectToNewObject("word.application.8")
, but I now need to do similar with LibreOffice writer if I can.
What parameter should I be applying to ConnectToNewO...
- Page :
- 1