Swaroop Kavi
New Member
- Joined
- Aug 25, 2021
- Messages
- 4
- Office Version
- 365
- 2019
- Platform
- Windows
Hello,
I am looking for a vba code to find a text file which contains the file name "_res_av_" in folders and subfolders, open it in excel, select column "A", Data > Text to columns > Delimited > Tab and Space, and save as excel file with the name same as text file in the same location.
I am looking for a vba code to find a text file which contains the file name "_res_av_" in folders and subfolders, open it in excel, select column "A", Data > Text to columns > Delimited > Tab and Space, and save as excel file with the name same as text file in the same location.