-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
convert txt to xlsx
-
T
open a txt file, edit it, then save it as an xlsx, then repeat for 200 additional files in the same folder
The below code works great... for ONE file. But the files are from 1800.txt to 2000.txt. How do I insert this into a loop so I don't have to enter a filename? It just opens every txt file in that folder, parses it, then saves it as the same name but as an xlxs file? Again, C:\temp\ contains 200...- tacoguy
- Thread
- convert txt to xlsx file folder loop a macro many files
- Replies: 2
- Forum: Excel Questions
-
E
[ASK] 1 macro to Convert txt into excel in mass
Dear gurus, I need to convert txt into excel, I have large amount of txt file that need to convert into excel which has delimiter (eg, comma, tab, or pipeline ("|"). My requirement is to have txt file on one folder and the converted file in another folder. My idea is: 1. Declare the folder...- esteem
- Thread
- convert txt to xlsx delimiter
- Replies: 1
- Forum: Excel Questions
-
M
Macro to loop thru folder and convert txt to xlsx
Hi, I am having trouble to loop thru a folder of txt and xlsx files; select the txt files (one by one), convert them to xlsx file (and maintaining the original txt file); save it in same path and with same filename (as when it was txt file, but .xlsx); Note:- must maintain the original txt...- mxman
- Thread
- convert txt to xlsx loop thru folder
- Replies: 2
- Forum: Excel Questions
