Excel, StrConv, and an HTML Form

[Albert]

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

 

[Rick Rothstein]

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.