This macro opens all calc files in one directory, and export each sheet of each file to one individual .csv file, named : filename_sheetname.csv

It is easy to customize to import/export from/to other format that OO can manage.

its is mostly copied from
http://www.oooforum.org/forum/viewtopic.phtml?p=194938#194938

Report abuse here