print text file with UTF8 encoding

I am trying to print from excel a text file of a sheet data, creating the text file works but I need to have it encoded as UTF8?? Here is the code I have to print.

Please Login or Register  to view this content.

Not sure if I need to add something to this or do I have to open the text file in Notepad and do the convert to UTF8 there?
Thanks
Dale

Try this:

Please Login or Register  to view this content.

Hi I am getting an error with this line
Set AsT = CreateObject("ADODB.Stream")
Do I need to change ADODB to something?

I made a mistake by assuming that the file you wanted to write to, exists ( Assumption = the mother of all FU).
- Added testing if the file exists and creating if not.
The code attempts to makes a ADODB connection with the file, so it must be existing.....

Please Login or Register  to view this content.

Great thanks that worked
Dale