Discussions tagged OLE

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...
For an Visual ActiveX control (.net dll) to be listed on the     OLECustomObject -> Insert object Dialog list.  Must it have a strong name be installed in the GAC Must it have an internal manifest resource packed in? Any other requirement...
I am working on some of features available in Appeon (PowerBuilder 2019) for upgrading from the old version. I need some information/help for the following topics Converting Blob into string I am encrypting the plain text using “SymmetricEncryp...
Hello everyone. I have a PB application which calls Outlook to send messages. I want to trap and log errors if any. Here is my code: ole_Item = ole_Outlook.CreateItem(0) ole_Item.HTMLBody = ls_Body ole_Item.Subject = 'Test message from PowerBuild...
Hi PBers I have searched on Google for a solution to this issue for a while now and I am turning to you for help. I have a saved doc in Word with 'fields' (not 'bookmarks') in it. I did so by going to Insert>Quick Parts>Field... I need to ac...
Hello. We are migrating a client/server desktop application from PB 12.5 to PB 19. Some of our OLEObject functionality appears to have broken, and I'm looking for some help. It's a homegrown DLL wrapper to C#. Here is a snippet of the code in questi...
  • Page :
  • 1