Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 203
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you populate an HTML form with EXCEL or DB file? Is it possible? [email protected] Excel Discussion (Misc queries) 0 January 20th 08 02:38 PM
Exporting Data from Excel Form to HTML Page Lenap Excel Programming 1 August 2nd 06 02:25 PM
Get text from a Html form josuegm Excel Programming 5 May 26th 06 12:26 AM
html form to update excel file on server. gr8guy Excel Programming 0 August 8th 05 09:33 PM
Unicode StrConv/Substitute routine... Tom Ogilvy Excel Programming 5 July 14th 03 04:37 AM


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"