I'm a total newbie when it comes to VBA, I'm learning a lot on this website.
The problem I have I can't click a link on a website with javascript on it. It's a page in my intranet so I can't provide a link. I have person names on Excel and want to access a website cliking on the names of those persons.
Here is the source portion from the webpage, the 'XXXXXXXXXX' is the specific name with 20-30 similar on each page, so the idea is get the name from excel and click on the appropiate link.
<a id="dg_census__ctl13_AppLink" href=",DanaInfo=10.32.112.141+patientdos.aspx?mrn=737300&ntlogid=YYYYYYY&Adm_Date=8/29/2012&LastSeen=8/30/2012&PatName=XXXXXXXXXXX&LastSubmission=&RealAdmDate=8/26/2012" target="_parent" style="color:#0000CC;width:80px;">XXXXXXXXX</a>
The
And this is what I have so far
Sub Census()
Dim ie As Object
Dim url As String
Dim PersonN As String
url = "https://access.............."
Set ie = CreateObject("internetexplorer.application")
ie.Visible = True
ie.navigate url
While ie.Busy Or ie.readyState <> 4
DoEvents
Wend
ie.Document.getelementbyid("rbl_DateRange_0").click
While ie.Busy Or ie.readyState <> 4
DoEvents
Wend
PersonN = Sheets("Sheet1").Range("A1").Value 'get name from Excel sheet
'Need to click on a link with that persons name HELP!
End Sub
TIA
Rick
Bookmarks