vba: FollowHyperlink ; is there a character limit workaround?

[RoccoDyce]

I am trying to build a hyperlink to match a 3rd party site's search string. They have their search setup to list every single field, even if blank, which makes for a long url.

I have found that I can build a url that would work if I cut and paste into a browser but I cannot use FollowHyperlink on the same url. The long url gets truncated to the first 1023 characters.

I have also tried to use the FollowHyperlink Extrainfo to see if it increases the length of the url but it does not.

Any suggestions?

 

[RoccoDyce]

bumpski

Feel free to just wish me good luck.

 

[Norie]

Are you sure you need the entire URL?

I've seen sites where you follow a link and the initial URL is much shorter than the URL you finally end up at.

Sometimes it seems to happen using some sort of redirection, other times via code or other methods.

Perhaps it's worth trying a shorter URL.