I'm throwing this out...NOT literally but just to see if anyone has a suggestion for the code below so that it sends authentication with the request.
Without username and password a popup window opens and requests username and password. Is there a step or two I'm missing to complete authentication?
Private Sub CreateBOM_Click()
Dim strBomChgUrl As String
Dim username As Variant
Dim password As Variant
strBomChgUrl = "http://.com/W/servlet/ EcnRptBomChange.xml?ecn_in=" & TextBox1.Text & "" + username = "user" & password = "pass"
Video Tutorials / Excel Dashboards Reports