I'm in a rather awkward situation in a current application I'm developing.
Basically, how do I use VBA enter a search sting into the following website:
and then get it to search. Then, read the search results and store them in the Database ?
I've seen other forums and have been made to understand that I need to get the "Name" or "ID" of the "Search Text" Control and that of the "Search" button. However, I have parsed the HTML document above and I can't seem to get either of their names.
I have the following code so far:
searchString = "smith"
Set ie = CreateObject("InternetExplorer.application")
ie.Visible = True
If ie.readyState = 4 Then
'Need Code to enter the search string into the Search Text Box
'Need Code to Submit the Search
'Need Code to read the returned Results
I can probably manage with the storing of the data in the Database, however, I need help with making reference to the "Name" or "ID" of the Search Text Box, Submitting the Results (or Submitting the Form) and Reading returned results
Any help will truly be appreciated.