Hyperlink a long URL of more than 255 characters
To get the drilldown feature we need to implement the hyperlink functionality to our excel report. we have tried the function Hyperlink ("URL","Friendly name"), but this functional supports only 255 characters. we have a URL containing 450+ characters. we are using the URL
We have tried the below options
1. Delivered Hyperlink function of excel (Doesn't solve our purpose, reads only 255 characters)
2. Concatination with the Hyperlink function:- some URL's are working fine but the URL given by us is not working. It throws the error as #value!
3. Right click on the cell then providing the URL and the URL name.(doesn't resolve our purpose as it reads only 255 characters)
4. Macro like
Sheets(1).Hyperlinks.Add Range("d2"), urladd, "", "URL Len: " & Len(urladd), "A Long URL"
we don't want to use the Marcos to acheive this task.
5. Got the below code from one of the user on ExcelKey as below
Function myHyperlink(cell As Range, _
hyperlinkAddress As String, _
Optional TextToDisplay As Variant, _
Optional ScreenTip As Variant)
Set cell = cell.Resize(1, 1)
If IsMissing(TextToDisplay) Then
TextToDisplay = hyperlinkAddress
If IsMissing(ScreenTip) Then
ScreenTip = hyperlinkAddress & " - Click here to follow the hyperlink"
cell.Hyperlinks.Add Anchor:=ActiveCell, _
' There doesn't seem to be another way to set TextToDisplay
myHyperlink = TextToDisplay
but this is also not working in Excel 2010.
can somebody please help us in acheiving our task in using the long URL as HYPERLINK ???????
Please don't suggest about http://tinyurl.com/ as we need a dynamic parameterized URL for reporting purpose.
PS: Please consider me a novice user of Excel while replying. Request you to please reply in detail including all the details.
email : email@example.com