ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 843
- Office Version
- 365
- 2019
- Platform
- Windows
I am looking for a way to open up .txt files and move them to an excel workbook to then format it to the way I want to so its legible. The issue I am running into is the files naming conventions are very unique. So I don't know how to call the VBA to open and loop through each file. For example:
CONTROL_FUNNA_US_D_20240408182134
CONTROL_FOFNA_US_D_20240408182052
Each file will have multiple occurrences and are saved with the Year month date hour minute and seconds at the end (YYYYMMDDHHMMSS). But for the sake of what I am trying to do I just need one by one open inserted into its respective sheet and formatted. With the file name next to the record that it came from. I am sure there is an easy way to do it but not sure I can currently find a way
FUN has its own sheet
FOF has is own sheet
Appreciate you taking the time to look as always
CONTROL_FUNNA_US_D_20240408182134
CONTROL_FOFNA_US_D_20240408182052
Each file will have multiple occurrences and are saved with the Year month date hour minute and seconds at the end (YYYYMMDDHHMMSS). But for the sake of what I am trying to do I just need one by one open inserted into its respective sheet and formatted. With the file name next to the record that it came from. I am sure there is an easy way to do it but not sure I can currently find a way
FUN has its own sheet
FOF has is own sheet
Appreciate you taking the time to look as always