texasguy66
New Member
- Joined
- May 31, 2023
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
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
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