importing with macro

[eggenspi]

Hello everybody,
I am currently trying to convert a great number of files from txt to .csv.
In fact I need to
1/ Insert data from a file , choose my file , ...
2/ import my data from column 7 to the end
3/ format the cell to have data with 7 decimals
4/ save this in a csv file.

As my text files are named "things i.txt" where i goes from 1 to 50, I guess it is easy to make a routine or a macro to do this, but I didn't find the command line to import data from a file, neither to format it, and when I try to save automaticly a macro, it only record the "save" part of my routine.
Do you have a solution.

Thanks a lot for your help
a newby

[Hagar Delest]

Hi and welcome,

You should try to look at the Andrew Pitonyak's document about macros (some links here IIRC), yuo may find some bits of macros that you'll be able to adapt afterwards.

I move your thread to the Macro forum, perhaps you'll get more attention.