Save excel data range in comma separated .txt file

Hi,

I have a range of data which I'm trying to save into a comma separated .txt file. Excel only allows one to save to a comma separated .csv file. Unfortunately the program I am trying to upload to requires comma separated .txt file.

I tried save to .csv file then opening in wordpad and saving as .txt file but unfortunately this means some of the blank fields are lost.

Please see attached file where the range of data I wish to export to comma separated .csv file is cells B1 : CI36. Further column T (Date) needs to be saved to .txt file in text format ddmmyyyy (i.e.: no "/").

When opening the .txt file the first line of the attached file would read:
,PYMNT12MAY11,,01,,RIV001,,,,,,,56001811149035,,,GBP,8640,,12052011,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Is the best way to write a macro to export the data?

Kind regards,
Sky