Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with German Characters

Status
Not open for further replies.
R3D3

R3D3

Programmer
May 1, 2002
34
FR
I have nice piece of code that brings data into my Excel macro from a file (I think I got it from Tek Tips long ago.)
-------------------------------------
hdle = 1
Open XML_FILE_NAME For Binary As #hdle

Do Until EOF(hdle)
Line Input #hdle, strLine
XML = XML & strLine
Loop
Close #hdle
-------------------------------------
This works fine but when there are special characters in the file they get translated to a different character

eg Straße becomes Straße

Anyone any bright Ideas?
 
Status
Not open for further replies.

Similar threads

office365
  • Locked
  • Question
i have a problem with a button sele 2
Replies
15
Views
339
combo
combo
Andrzejek
  • Locked
  • Question
Characters in file name 3
Replies
9
Views
162
strongm
strongm
gussy81
  • Locked
  • Question
mail merge with attachments 2
2
Replies
20
Views
416
Andrzejek
Andrzejek
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
134
aldi07
aldi07
osera
  • Locked
  • Question
Delete file from Sharepoint with Access VBA
Replies
2
Views
309
osera
osera

Part and Inventory Search

Sponsor

Back
Top