We have an Excel Macro's that import flat text files daily and sort them into meaningful data. These need to be converted into open office macros.
The text file is a flat file with predefined field lengths, these need to be seperated into cells.
After the data is seperated there will be several functions that sort the data in different ways.
ie by store and day.
I would prefer a like for like coversion for the excel macro, the scripting will need to be OO native and not require any plugin to work.