-
hyperlink
i am trying to create a hyperlink that is very long - the idea is that i am passing variables to a webpage... but i think i am running into a limit on the amount of characters that are allowed when just using the HYPERLINK() function. Is there a vba script that can get around this limitation?
Last edited by mdavison69; 07-29-2010 at 05:07 PM.
-
That depends.. how long is very long?
You could explore the likes of:
[VBA]strURL = "http://www.google.com/"
ActiveSheet.Hyperlinks.Add Anchor:=Range("A1"), Address:=strURL, TextToDisplay:="Google"[/VBA]or there is the .followhyperlink method.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
-
Thanks, i'll give it a try!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules