Thank you for your help but quite simply, no! It's saving a file as
UTF8 which is a specific encoding format, supporting more characters
than other formats. Excel does not natively support UTF8 despite it
being widely used. This code will allow you to do that, which I've
now tidied up and
After a few days looking around, I seem to have been able to solve
this myself despite never even having heard of what ADO Streams are
before:
code starts
'Function saves cText in file, and returns 1 if successful, 0 if not
Public Function writeOut2(cText As String, file As String) As Integer
do you want to save your workbook in text and csv format.check links below
in text
http://www.compshack.com/visual-basic/save-file-using-visual-basic-excel-macro
http://www.vbaexpress.com/kb/getarticle.php?kb_id=805
in csv