Spreadsheet Automation Using VBA


A collection of spreadsheets providing simple introduction to office automation using MS Excel and VBA. The focus is reading and writing files, and generating scripts for Acad LT.

One of primary programming tasks in engineering design is taking data from one application program and changing for use with another application. Having done that also useful if can run the application program from MS Excel, and retrieve the results into the spreadsheet. The vba shell command is useful for this purpose and illustrated by the running of Acad LT.