The University of Sheffield
Department of Computer Science

Chris Clarke Undergraduate Dissertation 2005/06

"An Excel / Open Office Macro Translator"

Supervised by Dr SD North

Abstract

Open Office is becoming increasingly popular, and as such the need for compatibility between Microsoft and Open Office applications is becoming ever more apparent. However, whilst Open Office allows Microsoft documents to be opened with their products, macros are not currently supported. The purpose of this project is to create a tool that allows the conversion of Microsoft Excel macros into a format that is supported by Open Office Calc. This project has not managed to create a complete solution that is able to convert macros from Open Office Calc to Excel. This project has however succeeded in creating a basic framework, converting some basic functions and allowing for further functions to be easily added.