Merging Multiple Text Files into One Excel Sheet

[dhsilv2]

Hi guys,

I'm trying to merge about 3k text files into a single excel sheet. Now this is easy enough to do with power query or even some VBA I've seen, but I also need to add a column with the file name as each file represents a different day's information. I can't seem to find a way to add that extra column to with power query and figured perhaps VBA was the way to go, but sadly I'm pretty poor with VBA.

Any help would be appreciated.

 

[sandy666]

try From Folder option, it will give you the file names

 

[alansidman]

Show us a couple of lines of data from each file and then what the changes you need to make. Difficult to provide any viable solution without seeing what your data looks like.

 

[dhsilv2]

Show us a couple of lines of data from each file and then what the changes you need to make. Difficult to provide any viable solution without seeing what your data looks like.

edit, looks like the prior post solved it. Thank you for your help. It was appreciated.

 

[dhsilv2]

try From Folder option, it will give you the file names

well no wonder I wasn't seeing results, it was so stupidly easy nobody could be confused. Thank you!

 

[sandy666]

you are welcome

have a nice day