I think your problem arises from your open function - try using the
following statement for opening your file :

Workbooks.OpenText Filename:=stCSVFile, DataType:=xlDelimited,
Comma:=True,_ Space:=False, Other:=False

Can then save this as a normal xls file.

Kind Regards

Stephen
Investment Operations
State Street
Edinburgh

"BHARATH RAJAMANI" wrote in message ...
Can someone guide me how to write a macro that Loops through 'N' .CSV files
in a desktop folder and saves them as .XLS files. It is important to
recognize the comma delimiter and throw the comma-separated individual values
in different cells. If I use a normalExcel fileproperty then my xls file has
all values in column A only.


TIA

Regards,

Superb!! thank you so much Stephen & Tom.


"Stephen Wortley" wrote:

I think your problem arises from your open function - try using the
following statement for opening your file :

Workbooks.OpenText Filename:=stCSVFile, DataType:=xlDelimited,
Comma:=True,_ Space:=False, Other:=False

Can then save this as a normal xls file.

Kind Regards

Stephen
Investment Operations
State Street
Edinburgh

"BHARATH RAJAMANI" wrote in message ...
Can someone guide me how to write a macro that Loops through 'N' .CSV files
in a desktop folder and saves them as .XLS files. It is important to
recognize the comma delimiter and throw the comma-separated individual values
in different cells. If I use a normalExcel fileproperty then my xls file has
all values in column A only.


TIA

Regards,