Using Excel as a front end to APL+Win

This article will discuss how we might use an Excel Workbook as a front end for an APL+Win application. The goal is to allow a user to start an Excel Worksheet, have it launch APL+Win as a COM object and pass control to make APL a client to that session of Excel. We want to minimize the number of Excel Visual Basic Macros we need to write. For each Excel Worksheet, APL will populate it, protect it, validate input, create input forms, and save the results in a database.