Thank you for your help.
I need to be able to pull up the below site and fill out the form. Idealy extracting the output generated.
Below is what I have so far:
I am having a problem with the form elements:
I need to be able to pull up the below site and fill out the form. Idealy extracting the output generated.
Below is what I have so far:
Code:
Sub SSI_MAcRO()
'
' SSI_MAcRO Macro
'
'_PULL UP FORM
Dim Ie
Set Ie = CreateObject("InternetExplorer.application")
Ie.Visible = True
Ie.navigate ("[URL]http://ssdi.rootsweb.ancestry.com/cgi-bin/ssdi.cgi[/URL]")
Do
If Ie.readyState = 4 Then
Ie.Visible = True
Exit Do
Else
DoEvents
End If
Loop
'USE VIEW SOURCE TO GET FORM ELEMENT IDS
Ie.document.forms(1).all("lastname").Value = Range("I11")
Ie.document.forms(1).all("firstname").Value = Range("I14")
Ie.document.forms(1).submit
'
End Sub
I am having a problem with the form elements:
HTML:
******** type="text/javascript" src="http://images.rootsweb.ancestry.com/js/rwhr.js">*********>
******** type="text/javascript" src="http://images.rootsweb.ancestry.com/js/oas_ssdi.js">*********>
******** type="text/javascript" language="javascript1.1" src="http://images.rootsweb.ancestry.com/js/o2.js">*********>
******** type="text/javascript" src="http://images.rootsweb.ancestry.com/js/o3.js">*********>
******** type="text/javascript">writeHeader('760px','Searches');*********>
******** type="text/javascript">OAS_AD('Top');*********>
Social Security Death Index (SSDI)
86,272,034
Search the Social Security Death Index by entering one or more fields in the form and clicking on the
"submit" button. Keep in mind that the more fields you fill in the more restricted your results
will be (and you may even eliminate the record you are seeking).
SSDI
Tutorial
• Missing Entries
• Reporting Inaccuracies
• Definitions, Search Tips
• Full Tutorial
RootsWeb's
Guide to Tracing Family Trees
U. S. Social Security Death Index (SSDI) and
Railroad Retirement Board Records
Last Name
ExactSoundexMetaphone
First Name
Middle Name or Initial
Social Security Number
******** type="text/javascript">writeFooter();*********>
******** type="text/javascript">
var s_pageName="SSDI Main Page - //ssdi/index.html";
*********>
******** type="text/javascript" src="http://img.rootsweb.com/omniture/omniture_tracking.js">*********>
******** type="text/javascript" src="http://id.ancestry.com/html/script/TSpacer.js">*********>