Comma Seperated Values UFT-8 Save in VBA

It looks as though you are actually putting quote marks in:

Please Login or Register  to view this content.

So, I would try:

Please Login or Register  to view this content.

However, that is totally untested.

If all you want is the Active (or only) sheet to be saved as a .csv file, you might be better off recording a macro to actually save the data as a .csv file.

See the following thread for information: http://www.excelforum.com/excel-prog...-workbook.html

Specifically, Post #4.

If you just record a macro while you save the active sheet as a .csv file, you get this:

Please Login or Register  to view this content.

and, if you tidy it up a bit, you can get this ... without being prompted by Excel

Please Login or Register  to view this content.

Then all you need is to add the lines of code (already provided by quekbc) to save the file and close it.



Regards, TMS

OK, can you post a sample workbook with some typical but non-sensitive data?

I recorded a macro to save as a .csv file, which gave me this:

Please Login or Register  to view this content.

Now, I've just saved it as a Unicode Text file format.

Please Login or Register  to view this content.

Problem is, I don't have data to test it with. But you can try that ... just change the output file name.


Regards, TMS