Convert csv files in folder to xlsm

[YasserKhalil]

Hello everybody
I need to convert files in specific folder from csv to xlsm and after conversion to split data to columns separated by the delimiter ;
Thanks advanced for help

[YasserKhalil]

Any idea about this issue?

[Leith Ross]

Hello Yasser,

I don't have the Arabic language pack installed for Excel but I do see the semi-colons in the text.

Will you be adding the VBA code to this workbooks at a later time?

[YasserKhalil]

Thanks a lot for offering to help Mr. Leith
Here's one cell

Please Login or Register  to view this content.

There is ; as you see

[Leith Ross]

Hello Yasser,

Thanks for the showing it in Arabic. Does your workbook show columns Right to Left or Left to Right?

[YasserKhalil]

The workbook shows columns Right to Left ....

[Leith Ross]

Hello Yaaser,

I thought it would. Just checking to be sure.

[YasserKhalil]

I didn't get what you mean ..
The workbook (csv file) shows columns from right to left ..
In fact data in csv file existed in one column and I need to convert to xlsm then split the data according the delimiter ;
Thanks a lot

[Leith Ross]

Hello Yasser,

Do want to convert only the files in the parent folder or all files in the parent folder and it's subfolders?

[YasserKhalil]

I want to convert all file in the parent folder and its sub folders ..and the results to be adjacent to their original files (in the same folder or sub folder)