excel encodes url

[oleg mirzaev]

Hi all,
I used this VBA in order to put URL in PivotTable:

https://www.youtube.com/watch?v=38wRYPEpJxY

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Dim selPF As PivotField
    Dim strField As String
    
    strField = "link"
    
    On Error Resume Next
    Set selPF = Target.PivotField
    If Not selPF Is Nothing Then
        If selPF.Name = strField Then
            ThisWorkbook.FollowHyperlink _
            Address:=Target.Value, NewWindow:=True
        End If
    End If
End Sub

the problem is that in some version, excel changes "#" to "%20-%20", thus the URL is not correct and causing an error.

Any thoughts why?

Thanks.

[Aaron092]

Have you tried setting strField as a value instead?

And where abouts is the hash in question?

[oleg mirzaev]

strField is just the name of a field that contains the URL (not the URL itself)...
sorry, didn't understand the hash question.

[Aaron092]

You said that the hash (#) is being changed to "%20-%20" - where is the hash coming from that's changing to %20-%20?
I thought it might have been in the URL.

Using strField = Value will copy everything in the cell as is. If it's the URL causing the issue, it should help if not fix

Would you be able to post an example?

[oleg mirzaev]

sorry for the delay...
i can't provide the code, it's classified information
i'm getting the values from DataBase via SQL server. the Data is ok and appear like correct "#"
when when you click it changes in the browser.

i still don't understand your suggestion to use Value. can you change it in the code i provided?