Hyperlink has changed on file re-opening

[tmarsh]

[Excel 2002, Win XP Pro]

Hi All,

i have cells in a sheet whose cell contents are hyperlinked to wor
documents. the hyperlink is generated using VBA. part of the fil
name includes the '[' and ']' characters (square brackets)

when the macro is run, everything works fine (click in one of the cell
and the appropriate word file opens) BUT when the workbook is closed an
re-opened, the '[' & ']' is changed to '%5b' and '%5d' respectivel
(which i guess is some srt of charatcer code for those symbols)

if the hyperlink macro is re-run, it 're-sets' the hyperlink and i
works again, until the next time the file is re-opened.

so, my questions are: why does it do it and how can i stop it!

tia,

ti

 

[Dave Peterson]

I've never seen this behavior. And I couldn't duplicate it in minor testing in
OfficeXP (2002).

But I'd weasel out and change the word document's name to not use []'s.

If you can't do that, maybe you could use the =hyperlink() worksheet function.
(I'm guessing that you used the equivalent of Insert|Hyperlink in your code.)

[Excel 2002, Win XP Pro]

Hi All,

i have cells in a sheet whose cell contents are hyperlinked to word
documents. the hyperlink is generated using VBA. part of the file
name includes the '[' and ']' characters (square brackets)

when the macro is run, everything works fine (click in one of the cells
and the appropriate word file opens) BUT when the workbook is closed and
re-opened, the '[' & ']' is changed to '%5b' and '%5d' respectively
(which i guess is some srt of charatcer code for those symbols)

if the hyperlink macro is re-run, it 're-sets' the hyperlink and it
works again, until the next time the file is re-opened.

so, my questions are: why does it do it and how can i stop it!

tia,

tim