Excel, StrConv, and an HTML Form
 

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

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