VBA Help rename files in folder and format data in renamed files

[jairamuk]

Hi Guys,

I need some help with the VBA code for excel 2010 to achieve the following processes:

Grab the csv filenames from C:\TEMP\
Place filenames in column 1
rename files to xls format in C:\TEMP\ based on data in column 2

then Format the renamed files:
Convert column A to whole numbers
Sum column L and place figure next to the respective filename in column 3 from above