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 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago