I have outdated and no-longer-supported Axis brand security cameras that I have to access via the their IP addresses on my local LAN. When I point Internet Explorer to their IP addresses a “Windows Security” small window pops up requesting username and password, which I then enter and then I can get into the security camera. I am trying to automate this with a 1-button click using my extremely limited programming skills. I got it to work — kind of — using the following code, but the problem is that if the camera has been logged into recently then it doesn’t ask for username and password and consequently the SendKeys function has Internet Explorer search the web for the pre-programmed password because it puts the password on the address bar\/search of the browser rather than sending the password text to the Window Security window which isn’t there. Is there a way to fix this or do this better than my stupid way? I will paste the code below, but is there a better language that I should be using than Visual Basic for which I could download the programming environment? I have a feeling someone out there could write this entire code over and in a better way in 10 seconds than what I came with below that took me several hours (embarrassed!):<\/p>\n
Sub Button1_Click()
\n‘
\n‘ Button1_Click Macro<\/p>\n
Set oIE = CreateObject(“InternetExplorer.Application”)<\/p>\n
sUsername = “user123”
\nsPassword = “password123”<\/p>\n
Set oIE = CreateObject(“InternetExplorer.Application”)
\noIE.Visible = True<\/p>\n
oIE.navigate “10.114.143.55”<\/p>\n
Application.Wait Now + TimeSerial(0, 0, 3)<\/p>\n
SendKeys sUsername & “{TAB}”<\/p>\n
Application.Wait Now + TimeSerial(0, 0, 1)<\/p>\n
SendKeys sPassword & “{ENTER}”<\/p>\n
End Sub<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":66},"question-category":[55],"question_tags":[],"class_list":["post-5089","question","type-question","status-publish","hentry","question-category-programming"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/5089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=5089"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=5089"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=5089"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=5089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}