Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing Text Data into Excel
Hello:
I have about 1300 CSV files that are all exactly formatted the same and named similarly i.e. Bom1.txt, Bom2.txt., etc. I want to convert each .txt file into an .xls file. Is there a way to do this by either: 1. Creating a macro to convert the .txt file to a .xls file. OR 2. Using VBA to batch convert several .txt files to individual .xls files. OR 3. Using VBA to batch convert several .txt files to individual sheets in a single .xls file. The .xls files could be saved with the same name as the .txt files in the same directory. Appreciate your help. "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing text file data into excel | Excel Discussion (Misc queries) | |||
Need to reformat text data before or after importing to Excel | Excel Discussion (Misc queries) | |||
Importing Text File Data into Excel where records span several row | Excel Discussion (Misc queries) | |||
Importing Text Data | Excel Discussion (Misc queries) | |||
IMPORTING TEXT DATA | Excel Discussion (Misc queries) |