merging .wks files using open office in one document

masterthesis · Newbie Joined: 28 Jun 2012 Posts: 1

Hi

My data is in the form of wks extension which opens with open office calc. All files have data which is in the same format.

I need to have the information from 640 different wks files in one table--one after the other. using the insert table from from option i could insert each file as a seperate table which might still work but its too time consuming and since I need to do the same thing for 640*10 files, I am looking for another solution.

Is there any other way to do it?
Any help would be really appreciated!
Thanks!

Villeroy · Posted: Thu Jun 28, 2012 6:02 am Post subject:

It would cost me at least one hour to gather all the required information and to write a macro.

Better you copy&paste 640 times.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org