View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Excel, StrConv, and an HTML Form

I'm not 100% sure of this (that means it is a guess<g), but I think you
might want to use the vbUnicode constant instead of the one you are now
trying to use.

--
Rick (MVP - Excel)


"Albert" wrote in message
...
Hi!
I have created a procedure that creates a small text (Dim MyText). This
text
is then converted using Strconv(MyText,vbFromUnicode) so that it can be
posted to a Web Form (via early binding to Internet Explorer).
The problem is I have to use some special characters in MyText, such as "á
ñ
é Ã*". Yet, after posting, the data that reaches de Web Form's Databse is
missing all those special characters. For example, if the original MyText
was
"ñamé", the database is getting "am". Where did the special characters go?
Any help GREATLY appreciated!
TIA,
Albert C