[Calc] Import txt to new sheet

[Monte94]

Hi all,

I am trying to import .txt files in to LibreOffice Calc with a macro (later i want to calculate on those files a lot, cause those are measurment datas).
I have read the whole day and found lots of tutorials and topics, i can get the path of those files, choose single or multiple, etc. But my problem is that i cannot read the .txt files in the same doc to single sheets. I tried with the loadComponentFromURL(URL, TargetFrameName, SearchFlags, Arguments) function, but i couldn't set the right parameter for TargetFrameName. ("_blank" creates a new doc, "MyFrameName" ((or anything else)) writes over the actual sheet. :/ )
So i would like to import some .txt files to the same calc doc, everyone to a different sheet. I am sorry if a topic has existed yet, and i thank a lot for a useful link to an example or anything else too.
Thank you very much!

[Villeroy]

viewtopic.php?f=21&t=77069 is a template with macro. It has one cell named "Target" and several other options in named cells, for instance path, pattern and import options of text files. It inserts new cells before "pasting" data so all your calculation references and names should update accordingly.