Multiple CSV Files

[marinosandria]

I have multiple directories such as SOBP,ORG,PREFIX. On each directory there are more than one text file. I need a hlp how to match all the txt files ina new folder. Can anyone help me to do that?

Thanks
marinosandria

 

[tehNellie]

I'm not quite sure what you're trying to achieve, but FileSystemObject might give you the tools you need to check different directories for filenames, move them around and so on.

 

[!Blue]

What do you mean by 'match all the txt files ina new folder' ..?

 

[marinosandria]

What i mean by match all the txt files. I mean that i have several txt files in several folders. The point iwantto read all the files at the same time and then save them all text files in anew single one file.

thanks
marinosandria

 

[!Blue]

If I've understood correctly - it appears what you may want to do is use the import feature to import all the files into one table, and then export the table as one csv file...

Main Menu > File > Get External Data > Import...

If you only need to this once it is not really necessary to write any code...