Power Query to manipulate webpage before collecting data
I want to import data from a webpage that does not itself update any information. This means that in order to get useful data out I have to manually enter a search string (text) on the webpage and also select a single filter option from a drop down menu. If I do this beforehand and then enter the resulting 'persistent' web address into excel the data in the resulting table never changes - because it refers to a 'persistent' search result that is frozen in time.
I want to be able to have Excel perform these manual operations for me. The way I imagine it working is:
1) You access the webpage from within Excel
2) You manipulate the page in any way you want; enter search strings, select from drop downs etc., and Excel REMEMBERS your steps!
3) When you refresh the query next time, Excel repeats each of your steps from last, in the same order (just like the existing Query Editor can perform a series of steps)
Denis Kostin commented
This idea is corresponding with my 2 paragraph (about interactivr web pages)