On Apr 30, 4:28 am, Martin Honnen <mahotr...@yahoo.de> wrote:
> Greg Lovern wrote:
> > strShiftJIS = StrConv(sText, vbFromUnicode, LOCALE_ID_SHIFT_JIS)
> > So the steps are:
> >  -- Save file from Excel as Unicode.
> >  -- Open file with FileSystemObject as Unicode.
> >  -- Convert text from Unicode toShift-JIS.
> >  -- IXMLHTTPRequest.Send the text asShift-JIS, to a server that
> > requiresShift-JIS.
>
> > Any suggestions on what I'm doing wrong?
>
> Have you checked whether the result of the StrConv() call does the
> proper encoding?
>
> --
>
>         Martin Honnen --- MVPXML
>        http://JavaScript.FAQTs.com/

We've tried but we don't know of a good way to do that, because with
the tools we have for either saving the text to a file or displaying
it, we're not sure if the character encoding is being changed.

I've tried:
 -- displaying the text in the Immediate Pane of Excel's VBA Editor.
 -- entering the text in an Excel worksheet cell.
 -- saving to a file with fso and viewing in Notepad.
 -- saving to a file with Write# and viewing in Notepad.
 -- saving to a file with Win32 API functions CreateFile, WriteFile,
and CloseHandle and viewing in Notepad.

Some of these resulted in the wrong Japanese characters, others
resulted in Japanese characters being converted to question marks.
None of them resulted in the correct Japanese characters.


Thanks,

Greg