All calculations and report formatting will be in APL, and will reside in an ActiveX server that VBA will call. All data, defaults and parameters will be stored in Access (see file discussion). Graphs will generated by Excel and written to GraphSheets in a new WorkBook and displayed in UserForms.
I will update this section as new forms are developed. This will become the marketing documentation of the system. All relevant buttons will eventually become links (especially the Menu Buttons and Helps), hovering over ComboBoxes will display the choices, and clicking on report menu entries will pop up sample reports.
The button for the viewer will appear and disappear, based on whether there is something to be viewed.
After everything else is done, I will convert over the Swaps section.
I wanted to have no visible sheet, but Excel requires there be one sheet visible. Now that I have one, I've embraced it. As you can see, I've got it quite minimal. Not even a cursor. Just a minimal splash screen. It will be used for returning the processing errors. A lot better than at the end of the report. When in displaying errors mode, three buttons will appear: (1) to put contents into the Clipboard, (2) put into Notepad, (3) and to clear. Clearing also clears the buttons and redisplays these messages.