Word 2007 VBA
I am reading a text file using the code below and storing in a string variable. However accented characters are coming in different to what they should be.
What can I do?
I'll try to included example but may not render correctly
Telefónica -> TelefÃ³nica
Function GetText(sFile As String) As String
Dim nSourceFile As Integer, sText As String
Dim lngChars As Long
''Close any open text files
''Get the number of the next free text file
nSourceFile = FreeFile
''Write the entire file to sText
Open sFile For Input As #nSourceFile
lngChars = LOF(nSourceFile)
sText = Input(lngChars, nSourceFile)
GetText = sText