asp.net - Excel VBA - Web Server Authentication popup -

i trying query spreadsheet web relay device (controlbyweb x310)x310 iot device. has built-in web servver , when manually browse url first time pops web server login page (not browser html window):

i've recorded macro of adding log data via excel insert "from web" data connection. uses recorded following vba:

with activesheet.querytables.add(connection:= _     "url;http://111.111.111.111:8080/log.txt", destination:=range("$a$1")).... 

within last item end statement ".refresh backgroundquery:=false" takes while it's thing returns nothing. if i've manually logged web page via edge browser , authenticated access, command returns need. have thousands of these devices sitting on internet need collect data script loop through each practical.

is there command or syntax querytables object can pass user id , password login pop-up? like:

with activesheet.querytables.add(connection:= _     "url;http://111.111.111.111:8080/log.txt", id:="name", pwd:="password" 

... not work.

i've searched high , low , found lot of info on login scraping html pop-up being service web server authentication. appreciated.