Excel vba to consolidate multiple .dat files into one

[texasguy66]

Hello,

Have several .dat files in a folder and would like to consolidate them into one excel file using vba. The layout is the same for every file. Would like to be able to select the folder where the .dat folders are.

I know it can be done with power query, but would like to stay with vba.

Has anybody had any luck with this so far? Thanks