I have around 100 excel worksheets stored in csv format in one single folder.
I have to save each and every single csv worksheet to xls format which is a
very cumbersome job. Pls provide me with some macro which automatically
converts all csv files stored in folder to xls format. Ideally that macro
should first ask me to point to location where all csv files are located and
then it should convert all files to xls format.