+1 for the oleinfo utilities Rony points to here. They were a great help to me in crafting and debugging a VBS script I was writing to help automate creation of an Excel report spreadsheet.
From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Rony G. Flatscher Sent: Friday, April 19, 2024 9:45 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: REXX vs other languages WAS: Rexx numeric digits and scientific notation question On 18.04.2024 15:14, Bob Bridges wrote: > I don't often admit it, because I expect to get flamed for it, but in fact > when I write in VBA almost all my variables are type VAR - that is, I hardly > ever use the Dim statement to assign a type. To introduce an array, sure, or > to maintain correct spelling in the longer var names. But it's rare indeed > that I feel the need to specify that a variable is going to be BYTE, STRING > or whatever. > > So obviously, coding in typeless REXX doesn't bother me 😊. :-) Seeing that you do quite a lot with OLE via VBA it may be interesting to take advantage of ooRexx 5.1 [1] little "oleinfo" utility [2] (see "oorexx\samples\ole\oleinfo" programs "createOleInfo.rex", "getOleConstants.rex", and "listProgIds.rex"). For those interested about OLE and what one can do with it see [3]. The generated HTML documentation about the OLE interfaces to Windows programs can be used for ooRexx and VBA alike. HTH ---rony [1] : Installation packages for oorexx 5.1: <https://urldefense.com/v3/__https://sourceforge.net/projects/oorexx/files/oorexx/5.1.0beta/__;!!Ebr-cpPeAnfNniQ8HSAI-g_K5b7VKg!PKDIGv21yG1HutL5OYw-GXz7XNI2i-z5hDkCqU1pXXZkBvLUD1Y4DHC_4gno0d5HunpmDb9SpOqWmDOTlSK6KNPxocSUcYbc$<https://urldefense.com/v3/__https:/sourceforge.net/projects/oorexx/files/oorexx/5.1.0beta/__;!!Ebr-cpPeAnfNniQ8HSAI-g_K5b7VKg!PKDIGv21yG1HutL5OYw-GXz7XNI2i-z5hDkCqU1pXXZkBvLUD1Y4DHC_4gno0d5HunpmDb9SpOqWmDOTlSK6KNPxocSUcYbc$>>. [2]: OLEInfo Utility: <https://urldefense.com/v3/__https://wi.wu.ac.at/rgf/wu/lehre/autowin/material/foils/130_AutoWin_oleinfo_V04.pdf__;!!Ebr-cpPeAnfNniQ8HSAI-g_K5b7VKg!PKDIGv21yG1HutL5OYw-GXz7XNI2i-z5hDkCqU1pXXZkBvLUD1Y4DHC_4gno0d5HunpmDb9SpOqWmDOTlSK6KNPxoc1JRMod$<https://urldefense.com/v3/__https:/wi.wu.ac.at/rgf/wu/lehre/autowin/material/foils/130_AutoWin_oleinfo_V04.pdf__;!!Ebr-cpPeAnfNniQ8HSAI-g_K5b7VKg!PKDIGv21yG1HutL5OYw-GXz7XNI2i-z5hDkCqU1pXXZkBvLUD1Y4DHC_4gno0d5HunpmDb9SpOqWmDOTlSK6KNPxoc1JRMod$>> [3]: OLE and Nutshell Examples: <https://urldefense.com/v3/__https://wi.wu.ac.at/rgf/wu/lehre/autowin/material/foils/110_AutoWin_V18.pdf__;!!Ebr-cpPeAnfNniQ8HSAI-g_K5b7VKg!PKDIGv21yG1HutL5OYw-GXz7XNI2i-z5hDkCqU1pXXZkBvLUD1Y4DHC_4gno0d5HunpmDb9SpOqWmDOTlSK6KNPxoRAs1_Tx$<https://urldefense.com/v3/__https:/wi.wu.ac.at/rgf/wu/lehre/autowin/material/foils/110_AutoWin_V18.pdf__;!!Ebr-cpPeAnfNniQ8HSAI-g_K5b7VKg!PKDIGv21yG1HutL5OYw-GXz7XNI2i-z5hDkCqU1pXXZkBvLUD1Y4DHC_4gno0d5HunpmDb9SpOqWmDOTlSK6KNPxoRAs1_Tx$>> > -----Original Message----- > From: IBM Mainframe Discussion List > <IBM-MAIN@LISTSERV.UA.EDU<mailto:IBM-MAIN@LISTSERV.UA.EDU>> On Behalf Of Rony > G. Flatscher > Sent: Thursday, April 18, 2024 06:30 > > The mileage of people here vary including the Java people themselves who have > started to reduce the need of explicit declarations like the new "var" > (imitating JavaScript) instead of strict types or foregoing the static main > method such that one can at least code the main method without the explicit > declarations. The motivation about these changes is to make Java easier, > reduce typing needs and the like. > > --- On 18.04.2024 02:22, Andrew Rowley wrote: >> I find Rexx difficult because explicit declarations and static typing (as >> well as tightly controlled scopes) actually make programming easier, in >> general. They show up bugs in the code and make it easier to write correct >> programs. -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN