Discussions tagged OLE
Problemas con Powerbuilder 2019 R3 y objeto OLE de Excel
- Issue
- Last updated 1 week ago
- John Fauss replied 1 week ago
Hola buenas,A ver si alguien me puede ayudar con esto. No puedo realizar la apertura de un excel, para hacer una importación de dicho documento:
OLEObject lnvo_excel
n_cst_datetime lnv_retardo
lnvo_excel = create OLEObject
// ...
CONNECTTONEWOBJECT return -3 in pb2022 . But in pb105 work fine.
- Resolved
- Issue
- Last updated 2 weeks ago
- Fabio Pontel replied 1 week ago
I have the same source code in pb10.5 and pb2022, both compiled in 32-bit.
In pb105, using the command CONNECTTONEWOBJECT("classolecomNONONONO") works.
However, in pb2022 it always returns -3.
What is the cause? How can I solve it?...
New Method: Drag and drop from Outlook via Webbrowser drag target
- Resolved
- How-to
- Last updated 3 weeks ago
- Jeff Kandt replied 1 week ago
We've been struggling, like a lot of people apparently, with providing the ability to drag messages and attachments from Outlook into our PowerBuilder app.
We had been using Dddll.dll from Catsoft, but that stopped working when Outlook went to 64-b...
Can't connect with oleobject to active directory SSL
- Resolved
- How-to
- Last updated 4 weeks ago
- Pedro Diaz Donoso replied 3 weeks ago
Hi,
I can't connect with oleobject to active directory SSL.
With a non SSL conection works fine. But now we need SSL
My code:
adoCommand = Create OLEObject
adoConnection = Create OLEObject
adoRootDSE = Create OLEObject
// Setup AD...
Hello all,
We're working on a project that will open Excel, call a stored procedure, create a chart, print as a pdf then close.Using PB2022R2 Build 2828.
Thanks to Tobias we have a very nice OLE example that does everything we need, except the abil...
We have existing processes to export something to excel using OLE and Excel VBA commands, which do their job, and then exit. We have a call at the end to an external function EndTask to kill the excel.exe process for these.
We're developing a new pr...
Unable to find the requested .Net Framework Data Provider
- How-to
- Last updated 4 months ago
- Mike Kolenda replied 4 months ago
Version 2019 R2 Build 2353
We have a PowerBuilder application (32-bit) that connects to a .NET DLL via OLE. Within this DLL we connect to Oracle using Provider Factories. We recent decided to stop using “System.Data.OracleClient” and have begun usin...
Looking for a solution of printing from PowerBuilder set of documents one after one (syncronic) the documents are in filesystem library.
I have docs from varios types, (Ex. docx, jpeg and pdf).
I succesfully print docx and jpeg via OLE to WORD, bu...
WebView Runtime warning popup message
- Resolved
- How-to
- Last updated 6 months ago
- Tim Ford replied 6 months ago
Is there anyway to suppress the "WebView runtime not installed" message when opening a window that has the WebBrowser control on it and the WebView2 Runtime does not exist?
We are currently transitioning from using old OLE controls for URL function...
IDE: registrationfree use of ActiveX-Controls - Use of Manifest file
- How-to
- Last updated 9 months ago
- Brian McCarthy replied 6 days ago
Hi,
We currently use some ActiveX controls in Powerbuilder. To be able to use the ActiveX controls without registering them at runtime, we decided to add manifest entries for the corresponding DLL files. The DLLs are deployed by us relative to the E...
Collecting a signature from a signature pad using OLE
- Resolved
- How-to
- Last updated 10 months ago
- shai hadashi replied 9 months ago
Hello,
I don't have much experience with OLE Objects and don't see too many examples online.
I am using the OLE control and able to get a signature from the TOPAZ signature pad in the IDE. When running the EXE I am getting "Error accessing Externa...
Create graphs in an Excel file from PowerBuilder
- How-to
- Last updated 1 year ago
- Mark Goldsmith replied 12 months ago
Is it possible to draw graphs in an Excel file from PowerBuilder? I create tables with data in Excel from PowerBuilder, but how can I build charts or pies based on this data? I saw that classes ExcelPieChart, ExcelBarChart, enum eChartType in C# are ...
Excel OLE: How do I reference a sheet by name?
- Resolved
- How-to
- Last updated 1 year ago
- John Fauss replied 1 year ago
Hi all,
I'm trying to import data from an Excel workbook using an OLE object. The algorithm works great, but I have hard-coded the WorkSheet number. How can I refernce the sheet by name instead of number? I specifically want to find the sheet nam...
How to handle ActiveX methods that have output parameters?
- Resolved
- How-to
- Last updated 1 year ago
- Mark Jones replied 1 year ago
I am using the Amyuni ActiveX controls for PDF processing. A couple of their methods have output parameters.
System.Boolean SearchTextEx(System.Int16 Start, System.String Text, [out] System.Int32 Page, [out] System.Double xPos, [out] System.Doub...
Error migrating with MSComm32.ocx
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
I am trying to migrate an application from powerbuilder 7.0 LOL
We used the mscomm32.ocx to communicate with a PLC via the Serial Port.
The client isn't looking to make any major changes (like communicate via TCP)
I have registered the OCX and...
Remove Oleobject dependency on MS Office install
- Advice
- Last updated 1 year ago
- Miguel Leeuwe replied 1 year ago
We have application that saves reports to Excel file using Oleobject and does data formatting after file is saved. This stopped working after MS Office was uninstalled form Citrix server due to company new policy. The file does get saved but erro...
Hello,I'm a bit stuck, google didn't deliver as good as it usually do this time around.I'm looking for a VERY easy and quick way to resize images from ex. 4k 8MB files to around 2-300 Kb files (let's say 72 dpi 1080p). Imagine doing this for common f...
Issue with OLE control in PowerBuilder
- Issue
- Last updated 1 year ago
- MARK APTEKAR replied 1 year ago
Hi, My PowerBuilder application (2019 R3 2703) is using third party control. It is working for a long time already without any problems when control is placed into the window (Insert->Control->OLE...). But now I cannot use window and trying ...
Performance Issue with OLE Document Preview
- Advice
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hello,
We a have an interesting performance issue. We have a datawindow of records relating to Word documents (stored in a blob column). When we click on a record another area of the screen uses an ole control to preview the document. We've been cha...
Calling .NET Components from PowerBuilder Via COM Wrappers...
- Resolved
- How-to
- Last updated 1 year ago
- Bruce Armstrong replied 1 year 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...
- Page :
- 1