Using VBA to click a button with no ID

Question

I'm trying to use VBA to navigate to a website and then extract some data. So far I've been able to navigate to the website and, but I can't figure out how to click on the buttons I need. Based on the research I've done, using querySelector is a much better option than using getElements.

When I inspect the button I'm trying to click on it brings me to the following line in IE's DOM explorer

<INPUT width="80" class= "button" onclick= "updateSummary();"  type= "button" value="Apply Filters"></input>

Based on my research, I've got the following: . . .

Ie.document.queryselector("input[value=Apply Filters]") (0).click

But I get a

runtime '438' object doesn't support this property or method.

I'd also like to be able to click on an "Export to CSV" button, and the html code has an href component and a source = "dynamically changing code based on the day" component.

Would it be possible to click on the export to to CSV button and either open the file or save it in a folder?

Thanks so much for the help!

may not be applicable, but strictly speaking, that's not valid HTML for the input definition. — user2366842
– user2366842, Commented Dec 7, 2018 at 17:17
document.queryselector returns either a single element or null if there's no match. So try dropping the (0) — Tim Williams
– Tim Williams, Commented Dec 7, 2018 at 17:29
Please ask a new question and include the relevant html for your second question. — QHarr
– QHarr, Commented Dec 7, 2018 at 17:55
If the object of clicking the button is to run the updateSummary() script, have you tried the execScript method to run it directly? — user10735198
– user10735198, Commented Dec 7, 2018 at 18:44

QHarr · Accepted Answer · 2020-10-22 03:33:30Z

1

Two things:

As mentioned in comments, drop the zero as you are not dealing with a nodeList. querySelector returns a single node which is the first match for the specified selector, or null.
You cannot pass a selector for attribute value that contains spaces without enclosing within ''
```
ie.document.querySelector("[value='Apply Filters']")
```

You could also use:

ie.document.querySelector("[onclick='updateSummary();']")

edited Oct 22, 2020 at 3:33

answered Dec 7, 2018 at 17:52

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using VBA to click a button with no ID

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related