Discussions tagged OLE
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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 ...
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