sleepingSatellite
Programmer
I have nearly 60 text files.
Every file is made of a series of rows of data. Each piece of data separated by semicolumn.
In principle I should open each of them (from Excel) as a text file, use the Text Assistant to recognize the columns and save in Excel-table format, in order to have the data available to be handled with Excel. Then repeat the procedure for every file.
Has anybody made a macro to do it automatically ?
Every file is made of a series of rows of data. Each piece of data separated by semicolumn.
In principle I should open each of them (from Excel) as a text file, use the Text Assistant to recognize the columns and save in Excel-table format, in order to have the data available to be handled with Excel. Then repeat the procedure for every file.
Has anybody made a macro to do it automatically ?