Convert Chinese character to UTF8 for hyperlink

W

wal

Excel 2003 (VBA 6.5)

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

http://address/xxx/罷
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top