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 - Save each sheet back to the F: drive. Each sheet would be saved as the name from cell ("G4").txt or .csv.
I have previously been using the print# feature as I wanted to save the file with space delimited and I had some commas that came out as "," which would not work in an already existing macro. If not a simple save may be possible.
Thanks for your time in advance people.
Lance
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 - Save each sheet back to the F: drive. Each sheet would be saved as the name from cell ("G4").txt or .csv.
I have previously been using the print# feature as I wanted to save the file with space delimited and I had some commas that came out as "," which would not work in an already existing macro. If not a simple save may be possible.
Thanks for your time in advance people.
Lance
