I'm trying to delete a web query connection after it loads in vba. I have used this code in the past, but suddenly I am getting the error: "Run-time error '5': Invalid procedure call or argument.
Dim lngConn As Long
url1 = Sheets("urls").Range("B1")
Sheets("data").Cells.ClearContents...