ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Convert Chinese character to UTF8 for hyperlink (https://www.excelbanter.com/excel-programming/444356-convert-chinese-character-utf8-hyperlink.html)

wal

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.


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com