Hi Guys,

Been looking fo a solution to this for a while, seems its quite a complex one and I'm 'Average' at VBA.

I created a bit of Code that helps me take an XLS files and make it a pipe delimited .txt file, the code for that is below:

Please Login or Register  to view this content.
Now I've been looking for a way to output this file as UTF-8 because I get funny characters appearing as ???????? which just won't do

I found this as the most talked about solution:

Please Login or Register  to view this content.
I'm looking for a way to incorporate this into my code if anyone can help with that? This isn't just a tell me how to do it, I'd like to understand how it works as well.

see my Feeble Attempt below that gives me an error saying it can't open the file 

Please Login or Register  to view this content.
Thanks a lot,
Liam