give column name to a csv file

So, you want to loop over all the files, and just add a line with the 4 headers at the very top, then save the resulting file?

Can you localize all the files to a single directory?

k, i can help i think. I have a similar loop in my personal macros. let me see if i can alter it for you

Ok, check out the attached file. You'll need to type in the full path to the folder holding the CSV's (note, it will actually look in any subfolders within that folder too), AND you will need to enter another path for the output.

Basically, the routine will alter each file and save it to a new file (so you will have the old files and the altered copy sitting in different folders)

Here is the code - the attachment should be good to go. Let me know how it goes please

Please Login or Register  to view this content.

Thanks man!! this was really good. However, there is just one slight problem..it is doing the right thing but instead of overwrting the current column names, it is adding a new one row with the four column n

previous file:

name1 name2 name3
1 2 3 4

new file:

H1 H2 H3 H4
name1 name2 name3
1 2 3 4

It is not overwriting the old column names in the old files but adding the new column names just above the old names. Is there any way I can produce this file:
H1 H2 H3 H4
1 2 3 4

I see that you have spent lot of time and energy on this and I am really thankful to you for the help you are putting in.

ohhh.... i thought the first row you mentioned was an example of what you were after. I see now.

I think it's a simple matter but I'll have to tinker with it later. I'll post what i find.

Man, it was really easy - just had to add a "skipline" to ignore that line

I posted it anyway because it might help someone else. Please mark your thread solved.

Please Login or Register  to view this content.