Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match 2 cell with chinese character value | Excel Worksheet Functions | |||
how do i type Chinese character in Office | New Users to Excel | |||
Chinese characters - UTF8 CSV files | Excel Programming | |||
Can I use Excel to convert Chinese character into Unicode? | Excel Discussion (Misc queries) |