Macro to import CSV and Combine two columns

[UTcse09]

My VBA skills are limited and the task given to me is beyond my skills, so any and all help will be appreciated.

I have several CSV files that I will need to import (can be one by one) with the number of columns changing each time. The information is divided by commas, and will need to be broken into cells. Once imported I need to take two columns that I will need to find by their header, and combine seperated by (-) into a third column denoted by another header. This will need to be done for all rows in the document. So for example if the file would be only three columns...

(A) (B) (C)

(1) a b a-b

Bolded is a random section of the information as it would look just opening in excel.
DevDbncOffDly.Deadband,Param.LoDevDbncOffDly.Input.DataType,

I am currently at work so I am doing this on a Windows Xp machine running Excel 2003.

 

[UTcse09]

My boss has just told me he would also like a button that he can use to do this, so they don't have to keep opening the Macro editer.