XLS to CSV and Rename Columns Automatically

Clareman

Hi All,

This has been wrecking my head, I thought I could do a little VB script but it's beyond me.

I have an xls file (Extract.XLS) with 10 columns, (ID No.,First,Last,Addr1,Addr2,Town,County,Country,Phone,Email), I need to save the file as a CSV (simple enough Save As to Import.csv I hope) but I also need to move a couple of columns around and rename the headers (First,Surname,Payroll,Address1,Address2,City,County,Country,Phone,Email). I'd love to be able to have a way of automatically doing it but if that's not possible if there could be a nice easy way to do it without much manual intervention.

garbeth

Will the Sb file always be in that format. Is yes then the excel file will always have the same columns in the same format. You can create a macro in excel that renames the columns to what you want them to be.

If you have any coding experience the code behind the macro is pretty easy to rewrite if you want to add anything fancy in.

The macro recorder basically just records what you are doing so it can be repeated when running the macro again.

Clareman

The file should always be in the same format so that's good to go, I never thought of the macro recorder option, I'll use that, thanks Garbeth.