CSV: Long Number Scientific Notation issue

Hi All,

I'm working on a master sheet which contains 50,000 users that belong to 140 departments. So I split them to 140 worksheets using this script:-

Please Login or Register  to view this content.

Then I save them as seperate CSV files using this script:-

Please Login or Register  to view this content.

My issue is that the master sheet has one column contains Arabic names and Two others Columns contain long numbers >15. So there are two Scenarios.
1-When I Save the files as xlCSVUTF8 the Arabic names are OK but Long numbers are converted in e.g. 9.71434E+14.
2- When I Save the files as xlCSVMac the long numbers are OK ( no scientific notation) but Arabic names are turned into ?????.

I have tried all the csv format but only UTF 8 accepts arabic.
Import Text wizard solution is not effective as I have so many files.
Is there any way to get all the csv files fixed and have Arabic names and numbers OK?

Thanks

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks