{"id":20543,"date":"2022-11-10T01:02:50","date_gmt":"2022-11-09T19:32:50","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/"},"modified":"2022-11-10T01:02:50","modified_gmt":"2022-11-09T19:32:50","slug":"solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/","title":{"rendered":"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-49015937\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"49015937\" data-parentid=\"48797081\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>OP here. Sorry for the terrible formatting of the question, it was the first time. To help others in the future&#8230;..<\/p>\n<p>This is what I did at first. It was my band aid fix.<\/p>\n<pre><code>ie.document.getelementByID(\"filtervalue\").select\n\"SendKeys{ENTER}\"\n<\/code><\/pre>\n<p>This highlighted my input value and just pressed enter. If you are new to VBA and need something to be immediately functional, just use .select and SendKeys and come back to it later.<\/p>\n<p>then, 1 week later, I figured out<\/p>\n<pre><code>Call ie.document.parentWindow.execScript(\"setUserIDAndRunDataspy();\", \"JavaScript\")\n<\/code><\/pre>\n<p>This, on the other hand just literally runs the event itself and is more reliable.<br \/>\nIn case you run into any issues, the first iterations I tried were something like<\/p>\n<pre><code>Call ie.parentWindow.execScript(\"setUserIDAndRunDataspy();\", \"JavaScript\")\nCall ie.document.execScript(\"setUserIDAndRunDataspy();\", \"JavaScript\")\n<\/code><\/pre>\n<p>They didn&#8217;t work for me, but worked for other scripts i checked. I&#8217;m not sure why though.<\/p>\n<p>Another solution you could try to though I haven&#8217;t tested it is what Tim Williams suggested. It would go something like this:<\/p>\n<pre><code>For Each ele In ie.document.getelementsbytagname(\"img\")\n              If InStr(ele.Value, \".\/images\/dsprun_out.gif\") &gt; 0 Then ele.Click\nNext\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] OP here. Sorry for the terrible formatting of the question, it was the first time. To help others in the future&#8230;.. This is what I did at first. It was my band aid fix. ie.document.getelementByID(&#8220;filtervalue&#8221;).select &#8220;SendKeys{ENTER}&#8221; This highlighted my input value and just pressed enter. If you are new to VBA and need something &#8230; <a title=\"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/\" aria-label=\"More on [Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[400,401,1650],"class_list":["post-20543","post","type-post","status-publish","format-standard","hentry","category-solved","tag-excel","tag-vba","tag-web"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] OP here. Sorry for the terrible formatting of the question, it was the first time. To help others in the future&#8230;.. This is what I did at first. It was my band aid fix. ie.document.getelementByID(&quot;filtervalue&quot;).select &quot;SendKeys{ENTER}&quot; This highlighted my input value and just pressed enter. If you are new to VBA and need something ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-09T19:32:50+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS\",\"datePublished\":\"2022-11-09T19:32:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/\"},\"wordCount\":173,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"excel\",\"vba\",\"web\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/\",\"name\":\"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-09T19:32:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS - JassWeb","og_description":"[ad_1] OP here. Sorry for the terrible formatting of the question, it was the first time. To help others in the future&#8230;.. This is what I did at first. It was my band aid fix. ie.document.getelementByID(\"filtervalue\").select \"SendKeys{ENTER}\" This highlighted my input value and just pressed enter. If you are new to VBA and need something ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/","og_site_name":"JassWeb","article_published_time":"2022-11-09T19:32:50+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS","datePublished":"2022-11-09T19:32:50+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/"},"wordCount":173,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["excel","vba","web"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/","url":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/","name":"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-09T19:32:50+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-getelementclicking-a-button-with-no-id-tag-name-class-value-siblings\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] (GetElement)Clicking a button with no ID, TAG, NAME, CLASS, VALUE, SIBLINGS"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/20543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=20543"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/20543\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=20543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=20543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=20543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}