I have a intranet site, which has options to filter the data, I mean filtering date, department, Location, etc..
I want to use excel VBA to make the selection automatically and get the results.
When I right click on page, view source/inspect/F12 is not available.
So I thought if we can get all elements of the web page to figure out elements and proceed accordingly.
Can you please help with the code which will loop through all the elements and give me details.
I want to use excel VBA to make the selection automatically and get the results.
When I right click on page, view source/inspect/F12 is not available.
So I thought if we can get all elements of the web page to figure out elements and proceed accordingly.
Can you please help with the code which will loop through all the elements and give me details.