Hi
I have been using Jerry Beaocaire's code to output CSV files, and it works great, except for 2 problems:
1: The delimiters being Comma, and I need them to be Semicolon. I have tried altering the code to FileFormat:=xlCSVMSDOS. But it makes no difference, I have also tried altering the windows setting, but it doesn't seem to affect it at all.
Is there any way to alter the code to use Semicolon instead of Comma ?
2: Im using thisAnd it seems to break the code to make the CSV files. Any suggestions on how to solve this. I was thinking maybe two buttons, one to sort with the above code(removing the macro from the worksheet), and one to make the CSV files.Please Login or Register to view this content.
Thanks for all help
Bookmarks