automate some steps in IE with vba

Hello everyone,

I have some issues with a scrap code that i gather from different sites, when trying to automate some process on a Internet Explorer page.


this are the issues that is stumbled on:
1. i add "Microsoft HTML Object Library" and "Microsoft Internet Controls", but when i enter again in the excel, they are not saved (.XLSM)
2. on the computer that i wanna automate the process, this is the step that is not working (even if on another computer is not having problems) - SetForegroundWindow HWNDSrc
3. the script that i scraped is not so good, doing some monkey stuff (like using the Tab button, 20 times). i was trying to change`t with a search for Name ID, but the program from the IE, is closed and is not permitting to inspect the elements.
so the third thing, there is any vba tool, that permit to find the Name ID, of a element that i click on?

the code that i made, is bellow

Please Login or Register  to view this content.

I have not used the HTML reference too much, but you clarify what you mean by this?

there is any vba tool, that permit to find the Name ID, of a element that i click on?

if that's what you mean, you can actually capture webpage control values by writing VBA and you don't need any lib references to do it. in your code, you are looping through ALL of them on the page, regardless of type. in order to capture properties of controls, you have to write javascript code usually and the same thing applies in VBA. it's just not called JS. the syntax on the following page is probably what you need to write to get IDs of any controls, if they indeed have them:

https://www.w3schools.com/jsref/prop_html_id.asp

also, for a lot of information of how to automated IE and/or do a little scraping of webpages without using SHELL, but rather just a simple IE object instance, see here:

https://www.access-programmers.co.uk...ng-vba.176968/

vba_php: Thank you for the answer. I will look on the links.