Hey guys,
Yes, I'm a NooB, I'm usually pretty quick at figuring things out via google-youtube, but I've been stuck for 3 days now.
I need to pull info from a table and insert it into my code (see below).
Private Sub cmdMBHPelig_Click()
Set objIE = CreateObject("InternetExplorer.Application")
objIE.Top = 0
objIE.Left = 0
objIE.Width = 1400
objIE.Height = 950
objIE.AddressBar = 0
objIE.StatusBar = 0
objIE.Toolbar = 0
objIE.Visible = False 'We will see the window navigation
objIE.Navigate ("web url")
Do
DoEvents
Loop Until objIE.ReadyState = 4
objIE.Document.GetElementByid("loginForm:loginPane l:username").value = "usernameid"
objIE.Document.GetElementByid("loginForm:loginPane lassword").value = "password"
objIE.Document.GetElementByid("loginFormroviderLogin_1_id3:submitButton").Click
Do
DoEvents
Loop Until objIE.ReadyState = 4
objIE.Visible = True
objIE.Document.GetElementByid("form1: eligibilitySearch: member_memberID").Value = "need to pull string from table"
' objIE.Document.GetElementByid("form1:verifyMemberE ligibility_1_id21:verifyMemberEligibility_1_id22") .Click
Do
DoEvents
Loop Until objIE.ReadyState = 4
End Sub