I am working on converting my DOS application to Windows. Finally. The
front end is all Excel forms driven from a toolbar. Then APL+Win running as >an ActiveX server to do the calculations and produce the output (but back
to Excel for graph formatting).
I have nested variables that contain the information for the custom report >writers. They include two strings that contain APL code.
In the DOS APL I have a full screen editor to manage the variables. For >Windows I could write something in APL+Win, but I have no idea how. So I >developed a VBA UserForm to manage them.
But how to display and read back the APL code? I would also need to be able >to paste code strings into the Textbox.
I started with two regular Textboxes and set them to the APL+Win font. They >displayed gobbledegook. I ran the code through AV2ANSI first. Some APL >characters appeared. But the up arrow went blank and the floor became a U >umlaut. (I did not try sending the strings back to APL.)
I looked into RichText boxes. I installed the Microsoft Rich Textbox
Control 6.0. But I get the error "The subject is not trusted for the
specific action." Possibly as I'm still using Excel 2002 (heh, the VBA is
If I upgrade my Excel, is this going to work for what I want to do? There
is also this: http://www.lebans.com/richtext.htm. But it seems so
complicated for something that seems simple to me.
My APL+Win is version 7.2. I will have to eventually sign up for a new >version, but once I do the two year clock starts ticking.
What is the solution for what I want to do?
For APL+Win, the obvious solution is to have it pop up its own edit
window. There's a manual about an inch thick about how to use the
Windows functionality of APL+Win--you should have either a paper copy
or a PDF or Word copy in the folder in which APL is installed or one
of the subfolders. There should also be a workspace with some example
The docs are not good but you should be able to figure out enough to
- Excel & APL+Win (or any other application) will NOT be able to share (interact with) a form - a form is only accessible by the thread that creates it. (There are workarounds but there are too onerous for production code).
- Neither an Excel form not an APL form will permit input using an APL keyboard; this rules out the entry of APL primitives in an edit box EXCEPT by pasting.
PS: try raising the question in https://groups.google.com/g/aplwin also.
Excel's text boxes have <font> and <multiple> properties; choose an APL font for the<font> property & set <MultiLine> to True.
1. If you have "Enable Unicode Clipboard' option under the APL+Win Edit menu option in v7.2, enable it.
2. If you don't, you will have to use AV2ANSI & ANSI2AV.
To me it seems that your intention is to use an Excel Form's textbox as an APL Editor - that is the hardest of all options available to you!
What ever happened to Jim Weigang? Looking up his West Springfield address
I find the house was sold in 1999 (and many times after that).
What ever happened to Jim Weigang? Looking up his West Springfield address >> I find the house was sold in 1999 (and many times after that).
Not sure, I emailed him some time ago, but his account at mit had been removed.
Let me know if there's another way to reach out to Jim.
|Location:||Huddersfield, West Yorkshire, UK|
|Nodes:||8 (1 / 7)|