Special Characters with Excel VBA Different Languages

[NYFashionToGo]

I do some sales in Europe and the address is typically supplied. There are alot of different characters in thier alphabet.not like USA.

I download a csv file (do not open it and run it through my tool I created using a query in excel. I have it set to text and I know the csv file (when opened in notpad) shows the proper character.. Is there a way with VBA to change it back... I dont know what to do about this annoying little problem. Or perhaps someone can point me in a direction of a different way... Any help would be appreciated.

Thank You

 

[NYFashionToGo]

Never mind, I found the answer, For some reason it was not working when I tried to edit my import query, However when I use a brand new sheet it works fine...So just added a worksheet and renamed it..