Hi,
I have a bunch of csv data here, all exactly the same layout and I want to create one spreadsheet document with many tabs from them.
Is there a way to do this by batch?
Importing several dozen files takes a lot of time…
Thanks and greetings,
Michael
This page might give you some hints for macros that can accomplish your goal:
http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=38587
You might have to tweak the code a little to suit your particular situation, but that looks pretty close to me.
Hi qubit,
tried this solution and it works very nice. Thanks for the link!
Greetings,
Michael
Hi @MiSt, You’re quite welcome! Did you have to change the macro code much to make it work? It would be great to have a short write-up from you so that if anyone else has the same question, they could follow your instructions. Thanks!
Hi cubit you are right,
My query is still not resolve its easy but I didn’t get proper solution
https://forum.openoffice.org/en/forum/viewtopic.php?f=20&t=78884&p=362011#p362011
this is my question
if you could help on this then it would be better
Many thnks