I am using EXCEL 2010 in windows 7.

I have a simple file

I need to do these things via VBA.

Copy Selected Range !A1:Q251
Ask an Inputbox for the file name
Save As file in CSV format in the below location
C:\Users\Mag\Desktop\Revenue 2012
Needs to create Converted folder, if not exists.

Appreciate all your help

Mag