Open multiple text files to different sheets and save each sheet seperately
Hi Excel gurus,
I've been pulling my hair out trying to do a potentially easy code for some experienced people, if anyone can help!
I'm looking to :
1) Open multiple file names from my F drive.
Details - With the file name of "issue303661.txt" the following file would typically be consectuive e.g "issue 303662.txt" but not necessarily.
Is there a way to have a simple macro that opens all text files in F drive no matter the name and inserts each text file into different worksheets that are space delaminated.
2) Renames each sheet to a specific cell
Details - in this case ("G4") of each sheet.
3) I have some code to manipulate the data
4) Save each sheet as a separate file
Details - Export each sheet back to the F: drive. Each sheet would be saved as the name from cell ("G4").txt or .csv.
Thanks for your time in advance people.
Lance
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago