View Single Post
  #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.