Discussions tagged OLE
How to upload and edit word template in powerbuilder
- How-to
- Last updated 2 weeks ago
- Miguel Leeuwe replied 1 week 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 1 month ago
- Aron Cox replied 1 month 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 4 months ago
- Armeen Mazda @Appeon replied 4 months 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 7 months ago
- Brage Mogstad replied 7 months 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 8 months ago
- John Fauss replied 8 months 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 9 months ago
- Konstantin Goldobin replied 9 months 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...
MSXML2 Load XML not working in Azure
- How-to
- Last updated 10 months ago
- René Ullrich replied 10 months ago
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...
PB application closes when we close OLE Object (Excel)
- Resolved
- Issue
- Last updated 1 year ago
- Miguel Leeuwe replied 1 year ago
Hello,
PB 2017R3
I use the following code to import data from Excel to Datawindow.
*********************************************
OLEObject xlapp , xlsub
dw_barcode.Reset()dw_barcode.SetTransObject(Sqlca)
ll_sheet = 1ls_filename = Trim(sle_fil...
Spellcheck window is not getting the focus
- Resolved
- Issue
- Last updated 1 year ago
- Miguel Leeuwe replied 1 year ago
I migrated a Powerbuilder application from 8.0 to 2019 R2. The application uses Microsoft Word Spellcheck to check the text in a RTF object. On Windows 7 computers, the spellcheck window appears and gets the focus but on Windows 10 computers the spel...
OleCustomControl causing application crash after migrating to PB2019R3
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
Hi,
we have one big issue after migrating to PB2019R3.
Migrate and Fullbuild is done. The error occurs in PB2019R3 before migrating and also after migrate/fullbuild .
The application crashes after loading OleCustomControl a few times.
The followi...
How to tell what object an OleCustomControl is using
- How-to
- Last updated 1 year ago
- Dan Cooperstock replied 1 year ago
I can't find any way to find out what ActiveX object an OleCustomControl on a window or user object is actually connected to. I see nothing in the UI (the Ole Control Properties and Ole Control Help buttons never seem to do anything), or in View Sour...
Problems with controlling OpenOffice via OLE
- Issue
- Last updated 1 year ago
- Dan Cooperstock replied 1 year ago
Using PB 2019, I'm trying to use OpenOffice through OLE to open an Excel doc and save it as CSV. (Yes, I can do that Excel, but this is for a situation where OpenOffice is available but Excel isn't.)
I'm running into two problems: the SaveAsURL (or ...
ole excel - Want to Find the last column Cell in a excel(Result should be for ex: Y6)
- Advice
- Last updated 1 year ago
- John Fauss replied 1 year ago
Regarding Ole excel - powerbuilder script
I Want to Find the last column Cell in a excel(Result should be for ex: Y6 or Z10)
using the below usedrange, script i can able to get the total columns and total rows
ll_xls_cols = excel.worksheets(1).Use...
Hi All,
We have several PB2017 applications that do extensive OLE automation to create formatted Excel reports. The formatting that we do is anything from basic column formatting (numeric and date) up to creating multi-tabbed workbooks with Auto Fi...
Is this a bug or my lack of knowledge?
In my application I have a command button to insert lines into a datawindow which displays different tables depending on the dataobject. For some tables clicking the button opens a response window for more ...
DLL accesed in runtime, not from PB IDE
- Resolved
- Advice
- Last updated 2 years ago
- Michael Kramer replied 2 years ago
Hi
I had to make some changes to a C# DLL due to urgent modifications fron some security required accesing external APIs, after that, the same DLL when running the application from PB IDE responds with error -3.I also checked for the deployed applic...
- Page :
- 1