Open Source Visual Basic for Applications (VBA) Code Generators

F2what is an open source project to translate algorithmic fortran to a variety of languages (java, dotnet and VBA so far). It offers a Fortran77 parser with code transformations, variable disambiguation, and modular output to other programming languages. It also offers already translated versions of Lapack and quadprog to Java, .Net and VBA, to give access to SVD, LU, QR, Cholesky, eigenvalue decomposition, linear system solving and QP optimization in those three languages.

TCL/TK is a rapid development scripting language but it's not object orientated. So instead of having classes and objects I wrote this program to generate blocks of commonly used geolog TCL/TK code. It automatically generates blocks of Tcl Puts code, Mui Dialog Boxes and Mui Selection Boxes from UNIX flat ascii files. To run the program load the XLA file into Excel then press CTRL + T to fire up the form. If your ascii files are in DOS rather than UNIX format you will not be able to generate proper TCL/TK code. The bar at the top of the form allows you to convert files from Dos to Unix if need be and check which format they are in. The difference between Unix and Dos ascii format is the line endings. DOS uses carriage return and line feed ("\r\n") as a line ending, which Unix uses just line feed ("\n"). In VBA these are Chr(13) <- return and Chr(10) < line feed

This XLS spreadsheet automatically generates TCL/TK command line interfaces for both UNIX and Windows environments. Originally written for xval the program https://sourceforge.net/p/xval/wiki/Home/ it generates button and clickbox select front ends for various different command line tools. Blocks of code are then generated from a simple spreadsheet format. The attached powerpoint explains which parts of the Excel spreadsheet generate which bits of TK front end. The generated TK front ends will then fire potentially any command line program. The buttons and click boxes don't fire the commandline programs directly they generate command line commands which appear in the CommanC box at the top. The red area at the top of the form runs the generated command line script The grey area in the middle generates the command line scripts its self And the box at the bottom of the form returns any readout from the command line while the script is executi