| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlinks to another file are changed to unicode characters
I have a spreadsheet which has hyperlinks to other files. Some of these files
are .msg files . The file name includes [ and ] characters. When we create the hyperlink and click on it, the hyperlinked file opens right up. However, once we save the file, the [ and ] characters are replaced with their unicode eqivelant %5b and %5d. When we try to click on the hyperlinks, Excel gives us an error message. Can someone suggest a workaround? thanks, Harry |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperlinks to another file are changed to unicode characters
create a sub for messages within the spreadsheet
"Harry" wrote: I have a spreadsheet which has hyperlinks to other files. Some of these files are .msg files . The file name includes [ and ] characters. When we create the hyperlink and click on it, the hyperlinked file opens right up. However, once we save the file, the [ and ] characters are replaced with their unicode eqivelant %5b and %5d. When we try to click on the hyperlinks, Excel gives us an error message. Can someone suggest a workaround? thanks, Harry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving double-byte characters as unicode text in a CSV file | Excel Discussion (Misc queries) | |||
| Changed Hyperlinks !! | Excel Worksheet Functions | |||
| Extra characters exported in unicode(.txt) format | Excel Discussion (Misc queries) | |||
| Exporting CSV file to unicode .txt file - " around strings | Excel Discussion (Misc queries) | |||
| inserting unicode characters | Excel Discussion (Misc queries) | |||
Linear Mode
