Import data from Excel to CSV (UTF-8)

[nmkhan3010]

Hi,

I have data in excel column A & column B . In column A we have native text of different languages and in column B we have respective english descriptions and we need to conver the data into .CSV (UTF 8) format.

Dialy we have more than 200 files and we need to convert individually and please write a macro to import the data from excel to UTF 8 and while importing data to CSV (UTF 8) it should ask to give a file name.

If not possible to assign a file name just give random name as "112233" and we will do individually only because for each file langauge is different and soucre and destination path should be same.

For more info. please find attachments.

Please do the needful ASAP...

Thanks In Advance....

 

[nmkhan3010]

Adding:
While importing to CSV (UTF 8) from excel it should ask to give the file name and then to select the destination folder where we want to import the csv file.

Please do the needful.