How to change Select Tag Option Value using VBA?

[headhair]

I am writing an Excel VBA code to fetch data from website.


The displayed data is paginated and select option is given to display the number of records

<select class="ui-paginator-rpp-options ui-widget ui-state-default ui-corner-left" value="20">
<option value="20" selected="selected">20</option><option value="50">50</option><option value="100">100</option></select>

There are more than 500 records. I want to display all data in one page so as grab them easily.
For that I need to change one of the above values from

<option value="100">100</option>

to

<option value="800">100</option>

and fire selection.


Is it possible change option value of select tag once the page is loaded using excel VBA?


Help needed.

 

[mole999]

can you do that manually in the query bar, not many sites allow an over select?

 

[headhair]

Thanks for replying.
It is an automated work.

 

[mole999]

i appreciate you want to automate a manual task, i'm just suggesting that it may not work, if you can do it manually then it should be possible