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.
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.