Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you populate an HTML form with EXCEL or DB file? Is it possible? | Excel Discussion (Misc queries) | |||
Exporting Data from Excel Form to HTML Page | Excel Programming | |||
Get text from a Html form | Excel Programming | |||
html form to update excel file on server. | Excel Programming | |||
Unicode StrConv/Substitute routine... | Excel Programming |