On 08/10/2008 09:23 AM, Dean Allen Provins, P. Geoph. wrote: > On Sat, Aug 09, 2008 at 12:10:29PM -0700, NoOp wrote:
>> Google shows a commercial application that does this: >> http://www.sobolsoft.com/calcjoinfile/ >> Disclaimer: I've not tried it, I just found it with a google search >> http://www.google.com/search?hl=en&q=openoffice+%2Bcalc+%2Bbatch+import+files > > Did you try copy and paste? Seems to work within OO. > Perhaps you missed his previous: > Hi Brian, > > thanks very much for your reply, both alternatives work fine. But if you > work with a lot of files, let`s say 20 - 50, to be combined and you have > to do that job once every 2 weeks it would be cool to find a more > effective way to do it. That is why I am looking for a way to kind of > automate this. The batch import was just one idea, because the files to > be imported will always be in one folder and will always have the same > names. I do not necessarily need all the data combined in one file, it > would also be OK just to import certain columns from the original files > to my main document. Is that somehow possible, maybe with a macro? > > Kind regards, > > Christian --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
