Hi, I have the following, pretty straight forward macro:
D31 and B31 both have a concatenate formulas that form up different URLs. It's been working perfectly for months, but recently, the following URL is not working:
If I copy the value of the cell, go to Chrome and paste it manually, it loads no problem. Also, if I change the concatenate formula to say: Google, it works perfectly.
So basically, the macro works for other URLs and the URL I want is loading no problem when loading it manually/on any explorer. Maybe it's some sort of block that's been added to that specific website?
Thanks in advance!!
VBA Code:
Sub LoadLinks()
Dim URL As String
URL1 = Range("D31").Value
URL2 = Range("B31").Value
ActiveWorkbook.FollowHyperlink URL1
ActiveWorkbook.FollowHyperlink URL2
End Sub
D31 and B31 both have a concatenate formulas that form up different URLs. It's been working perfectly for months, but recently, the following URL is not working:
If I copy the value of the cell, go to Chrome and paste it manually, it loads no problem. Also, if I change the concatenate formula to say: Google, it works perfectly.
So basically, the macro works for other URLs and the URL I want is loading no problem when loading it manually/on any explorer. Maybe it's some sort of block that's been added to that specific website?
Thanks in advance!!