getelement

Dear all, I am trying to input text into a webpage and search and am running into problems. Below is my code Sub GetHTMLDocument() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument Dim HTMLInput As MSHTML.IHTMLElement IE.Visible = True...

Hi I am new to this, i watched a few tutorials and tried out on my own and realize that i can't even do a search in the search box of the webpage. Below is my code that i tried. Sub Automate_IE_Load_Page() 'This will load a webpage in IE Dim i As Long Dim URL As String Dim IE As...

Hi, on an internal web which only runs in IE or GC there is a button with id="ext-eng-123" where 123 is a set of 3 numbers that change everytime the page is clicked. It appears it is a set of up to maybe 20 different combination, so not many. The whole line reads: <td align="left"...

Hi, Please i need to get a div with class="table" from the web link below https://www.learnthat.org/pages/view/roots.html Thanks and regards Vicedo

Really stumped here. I've managed to scrape a website's results page (Insurance eligibility) and get some results I want and dump it into my Excel file....except for one. I've tried numerous variations of the getelementbyid/classname/ This is my current code which isn't working, and yes, I am...

Hello All, I am having trouble being able to capture what I need from an HTML website to extract data for my VBA code. My code automatically uses a webpage to search the distance between two airports. That part works fine, extracting the actual value of the distance is giving me problems. The...

Situation: I need 2010 Excel to take a list of stock symbols (changes daily) given to me daily, login to an internal company website and query our accounts to see who holds the stocks in question. I need the returned query to be copied back into excel for manipulation. <?xml:namespace prefix = o...