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