CSV Format Issue

Good afternoon,

I'm running the code below which is dumping my file out in CSV which is perfect, however it seems to be losing some of its formatting I think which is causing a problem. With the CSV i usually load it into a system, but this file is not getting accepted into the system however if i open the file and save it again as a CSV it works......Weird. Could it be something to do with the message ".csv may contain features that are not compatible" which i am ignoring due to the Application display alerts = False line in the code?

Please Login or Register  to view this content.

Thanks in advance

Both files look the same, its just weird. If the macro saves the work sheet i have the problem loading into the system but if I run exactly the same steps or open the file generated by the macro then re save it, it works fine.

Also if I add the opening and closing of the file and re saving it by using an extra piece of code to perform this task then i get the same result (Non Working File)

What does "loading it into the system" involve? What system?