View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rainer Bielefeld Rainer Bielefeld is offline
external usenet poster
 
Posts: 14
Default need help creating a Batch-File

found a workaround/solution:

for me it's good enough just to replace german umlauts (ä, ö, ü, Ä, Ö, Ü).
I will never use other characters which may be different.

vCommand = Replace(vCommand, "ä", Chr(132), 1, -1, vbTextCompare)
vCommand = Replace(vCommand, "ö", Chr(148), 1, -1, vbTextCompare)
vCommand = Replace(vCommand, "ü", Chr(129), 1, -1, vbTextCompare)
vCommand = Replace(vCommand, "Ä", Chr(142), 1, -1, vbTextCompare)
vCommand = Replace(vCommand, "Ö", Chr(153), 1, -1, vbTextCompare)
vCommand = Replace(vCommand, "Ü", Chr(154), 1, -1, vbTextCompare)



"Rainer Bielefeld" schrieb im Newsbeitrag ...
Hi,

I'm trying to generate a DOS-Batchfile out of Excel and everything works fine until there are german umlauts (like ä, ö, ü) in
it.

E.g. if I write a command like

mv c:\ae.txt c:\ä.txt

to the file and I execute the Batchfile the prompt shows

mv c:\ae.txt c:\õ.txt

So, ä gets replaced by õ

I'm creating an Ascii-File

'create Batchfile
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.OpenTextFile(vBatchFile, 8, True, 0)

but it looks to me that there are differences between ASCII-Format and DOS-Format.

Any ideas?

Best regards,

Rainer