Search results

As Cringer posted, one option is to create Excel XML files, and although you can not create with advanced features they do not require any interaction with Excel. Apart from DocxFactory, a pure Progress solution to create Excel XML files is to use xmlspreadsheet.p written by Tom Bergman. I...

Also to add, for actual deployment if users are only running compiled programs then they do not actually require access to assemblies.xml. When you run from r-code, you don't need the assemblies.xml file because the assembly-qualified name of all referenced classes are in the r-code. If...

For PDSOE I normally just place in the relevant Project folder and it is automatically picked up. Another option is to set using the -assemblies parameter for the PDSOE project startup parameters - see attached.

Seems you have hit on the correct solution: https://community.progress.com/s/article/P21248 This is useful to know and better than using this method: https://community.progress.com/s/article/18664

This line is the cause because you have icsw.cono = icsw.cono: can-find(first icsd where icsw.cono = icsw.cono and icsd.whse = icsw.whse and icsd.ecommercety = 'y' no-lock) Change to icsd.cono = icsw.cono - you also do not require the no-lock for a can-find: can-find(first icsd where...

Although not Progress, a good alternative is to download the "Excel 2013 Developer Documentation.chm" file - Download Office 2013 VBA Documentation from Official Microsoft Download Center - and even though it is for an older version very useful because as you can see from the attached it works...

I initially thought that the Progress COM Object Viewer listed them all but as can be seen from the attached not the case. There are sites such as these that list the numeric values: https://learn.microsoft.com/en-us/office/vba/api/excel.xlautofilltype...

You can certainly run macros contained in other files using something similar to this: hExcel:Run("'Another Workbook.xlsm'!NameOfMacro"). As for loading info from another workbook that could be possible and think I did something similar many years ago but it is so long ago just cannot find it...

Really surprised by this as it appears to by design: https://community.progress.com/s/article/P116984 Can you apply the suggested resolutions? If you need to export multiple tables then this dynamic option may be useful: https://community.progress.com/s/article/P4410

It is certainly possible to run an Excel macro from 4GL, and as a quick test created a simple macro in an Excel file which was the following: Sub Macro1() MsgBox "Hello World." End Sub Running this code in 4GL gave the message: DEFINE VARIABLE hExcel AS COM-HANDLE NO-UNDO. DEFINE VARIABLE...

What you have done sounds fine and a possible improvement is to use Super Procedures: https://docs.progress.com/bundle/abl-reference/page/ADD-SUPER-PROCEDURE-method.html https://docs.progress.com/bundle/openedge-develop-abl-applications/page/Guideline-1-Use-a-single-super-procedure-stack.html...

Yes, unfortunately, of all the links I listed here - Seeking great OpenEdge GUI development tutorial - only this is still valid: https://community.progress.com/s/question/0D54Q00007tFpLaSAK/openedge-ultra-controls-for-net-illustrative-samples To start you off, have a read of the GUI for .NET...

For a quick example connect to the Sports2000 database and run something similar to this: /* runorderstreeview.p */ DEFINE VARIABLE oOrderstreeview AS orderstreeview NO-UNDO. oOrderstreeview = NEW orderstreeview(). oOrderstreeview:Show(). WAIT-FOR...

For (2), as Rob outlines, the AppBuilder functionality is integrated into PDSOE and the good news is this allows you to create character based UI's using either of the TTY options:

Tom, you are correct about LOAD and SAVE but have been assured no-one is doing that. Peter, thanks for the link, and trying some things can confirm that the procedure editor can set this if you do not specify a program to run. If the shortcut is similar to this it does not appear to change the...

In the past few weeks a shared Windows ini file on the server has twice had changes to the Proedit section, and although the changes have not affected anything I would like to know who or what is causing the changes. Whatever is happening is changing the settings from: [Proedit]...

As Cringer posts, it should be painless, and if the index is for a new table that is being added then it can be active in the DF, and can all be applied online when you select the 'add new objects online' option.

I have previously had this exact problem and the change that Stefan posted appears to be the only option. If you change to this it works: define variable dcQty as decimal DECIMALS 6 format "->>,>>>,>>9.9<<<<<<<<" Label "Qty" no-undo. As Stefan says it is a balancing act and maybe not ideal to...

As Cecil posted it is a startup parameter so will not work putting in an ini file. Something to note, if the other users are only running compiled programs then they do not actually require access to assemblies.xml. When you run from r-code, you don't need the assemblies.xml file because the...

Ah right, that does not work. You can do something like this with SendKeys but unfortunately do not know the correct text for CTRL-V: System.Windows.Forms.SendKeys:Send("e"). System.Windows.Forms.SendKeys:Send("~{END}").