Followhyperlink converts characters

[Kenji]

Everytime I send a string through ActiveWorkbook.FollowHyperlink, certain
characters get converted. For example "<" becomes "%3c"

Anyone know a solution to this? Thanks!

Kenji

 

[Jim Gordon MVP]

Hi Kenji,

It's probably just using the hexadecimal equivalent to the character. For
example %20 is the space character.

A longer explanation is here:
<http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=pan.2002.07.26.1
3.14.45.970239.19036%40goddamn.co.uk&rnum=16&prev=/groups%3Fq%3D%252520%2Bin
stead%2Bof%2Bspace%26hl%3Den%26lr%3D%26ie%3DUTF-8%26start%3D10%26sa%3DN>

 

[John McGimpsey]

Everytime I send a string through ActiveWorkbook.FollowHyperlink, certain
characters get converted. For example "<" becomes "%3c"

Anyone know a solution to this? Thanks!

I'm not sure why you're looking for a solution. .FollowHyperlink
automatically resolves the address, which includes "escaping" reserved
characters like "<", which can be a URI delimiter, into its %-hex-hex
form. The resolution is (or should be) done per the internet standard
RFC 2396. See

http://www.ietf.org/rfc/rfc2396.txt?number=2396

Proposed standards have loosened up the need for escaping, and many
browsers resolve the characters before making the URI request, but the
escape sequences are still the standard.

As part of a URI (Address), < and %3c are equivalent.

Now, since you asked the question, I assume you ran into a problem with
the way .FollowHyperlink resolves the URI. Can you give more details?

 

[Kenji]

I'm trying to POST a XML file to my server.

I generate the XML file on my excel sheet and then POST it to the server.

<XML>
turns up as
%3cXML%3e which is not XML.

I tried doing what Jim Gordon said, but it does not work. I still get a %3c
instead of <

Kenji