Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
wal wal is offline
external usenet poster
 
Posts: 8
Default Convert Chinese character to UTF8 for hyperlink

Excel 2003 (VBA 6.5)

Some websites allow either of the following URL formats ("*"
represents a Chinese character):

http://address/xxx/%E7%BD%B7
http://address/xxx/*

For this situation, the following simple code adds a hyperlink to a
column of cells, each having one Chinese character:

Dim cc
For Each cc In Range("MyRangeA")
ActiveSheet.Hyperlinks.Add anchor:=cc, Address:="http://address/
xxx/" & cc
Next cc

Unfortunately, some websites work only if the Chinese character is
encoded as in the first URL example above, which I think is UTF8.

Is there a way to adjust my macro to get the corresponding UTF8 code
for each character/cell in the range? Thanks.
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
match 2 cell with chinese character value AskExcel Excel Worksheet Functions 1 November 9th 07 08:17 AM
how do i type Chinese character in Office John New Users to Excel 0 March 9th 07 10:25 PM
Chinese characters - UTF8 CSV files [email protected] Excel Programming 8 August 24th 06 04:46 PM
Can I use Excel to convert Chinese character into Unicode? Richard Hsiao Excel Discussion (Misc queries) 0 September 22nd 05 10:06 AM


All times are GMT +1. The time now is 10:40 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"