I cannot supply you code till I am at work tomorrow (12 hours) but yes there is a way to do this. But I need you to tell me how you identify your internet explorer and that it is on the right webpage.
The easiest is the URL (if it does change and is unique) or the title of the HTML document. We need this because Internet Explorer has tabs.
If you can give me unique qualities of the webpage then I will get you something.
Also from the table is this one row the only row you want?
I really appreciate your help! The IE window is identified by the title:
Window1 = FindWindow(vbNullString, "Page Title")
I've tested it and this part of the code does work (makes the window active).
There will be several fields on the page I will send data from Access to, identified by the name of the field:
Me.AccessField1 = IE.Document.All.Item("ui_rateedit_rate1D1").Value
Me.AccessField1 = IE.Document.All.Item("ui_rateedit_rate1D2").Value
Me.AccessField1 = IE.Document.All.Item("ui_rateedit_rate1D3").Value
Me.AccessField1 = IE.Document.All.Item("ui_rateedit_rate1D4").Value
So far I have not run into any fields that do not have a name, so I don't think that will be an issue.