get data from a asp .net web site (java script) (1 Viewer)

[harish.gajawada]

can any one help me get data from web site to excel using vba and send data to forms in website .
please find the source code bleow after logging in to website it has frames and I am able to click on button of first frame (source code is below)

src="GFDomainBlank.jsp?caller=lookup" onreadystatechange="top.lookupStateChange();" scrolling="no">*********>
style="display: none; visibility: hidden; position: absolute; left: 0; top: 0; width: 0; height: 0; z-index: 0;">
******** id="activeServerComm" name="activeServerComm" src="GFDomainBlank.jsp?caller=activeServerComm" >*********>
******** id="contextServerComm" name="contextServerComm"
src="GFController.jsp?action=contextGet">*********>
******** id="logoffServerComm" name="logoffServerComm" src="GFDomainBlank.jsp?caller=logoffServerComm" >*********>
******** language='javascript'>
var lifeCycleInits = 0;
var lifeEventNames = new Object();
var initializedApps = new Object();
var initializeFailed = new Object();
var initializeFailedReason = new Object();
lifeCycleInits++;
initializedApps.lifeEventIFrame1 = false;
initializeFailed.lifeEventIFrame1 = false;
initializeFailedReason.lifeEventIFrame1 = '';
lifeEventNames.lifeEventIFrame1 = 'lifeEventIFrame1';
*********>
******** id="lifeEventIFrame1" name="lifeEventIFrame1" src="GFDomainBlank.jsp?caller=lifeEventIFrame1">*********>
******** id="lifeEventFrame2" name="lifeEventFrame2" src="GFDomainBlank.jsp?caller=lifeEventFrame2">*********>










and in it i have buttons with names
(newdiv)--->when i click on this i have other buttons with name
(announcements)--->under this i have more buttons with names
(announcement summery)
when i click on announcement summery it shows other frame with below source code

















****** HTTP-EQUIV="Pragma" CONTENT="no-cache">

****** HTTP-EQUIV="Expires" CONTENT="follow,noindex">
******** language="JavaScript" src="../javascripts/preForm.js">*********>





****** http-equiv="Content-Type" content="text/html; charset=UTF-8">


******** language="JavaScript" type="text/javascript" src="../javascripts/preForm.js">*********>******** language="JavaScript">function process_form(action)
{
if (action == "Search")
{
disableScreen();

top.setContextValue("GenericSecurity",document.Announcement_Inquiry.SECURITY.value);
top.setContextValue("AnnType",document.Announcement_Inquiry.ANNTYPE.value);
top.setContextValue("SecurityType",document.Announcement_Inquiry.SECTYPE.value);
top.setContextValue("DateType",document.Announcement_Inquiry.DATETYPE.value);
top.setContextValue("Date",document.Announcement_Inquiry.DATE.value);
top.setContextValue("AnnouncementStatus",document.Announcement_Inquiry.ANNSTAT.value);
top.setContextValue("GenericKey","");
if(document.Announcement_Inquiry.BROKERTYPE.value == 'U')
{
top.setContextValue("Recurring",document.Announcement_Inquiry.RECURIND.value);
}
document.Announcement_Inquiry.BWDKEY.value = "";
document.Announcement_Inquiry.FWDKEY.value = "";

document.Announcement_Inquiry.submit();

}

if (action == "Next")
{
disableScreen();
document.Announcement_Inquiry.PAGEFBIND.value = "F";
document.Announcement_Inquiry.submit();
}

if (action == "Prev")
{
disableScreen();
document.Announcement_Inquiry.PAGEFBIND.value = "B";
document.Announcement_Inquiry.submit();
}

if (action == "Clear")
{
this.Announcement_Inquiry.SECURITY.value = "";
this.Announcement_Inquiry.SECTYPE.value = "";
this.Announcement_Inquiry.DATETYPE.value = "";
this.Announcement_Inquiry.DATE.value = "";
if(document.Announcement_Inquiry.BROKERTYPE.value == 'U')
{
this.Announcement_Inquiry.RECURIND.value = "";
}
this.Announcement_Inquiry.ANNTYPE.value = "";
SetAnnouncementStatus();
enableScreen();
}
}


function AddPopup(Token,ClientNumber)
{
var popup;
var URL;
URL = '../common/main2.jsp?//dp_MESSAGE/@Message_id=DIV/DV02_DISPLAY&//dp_MESSAGE/@Token=' + Token
+ '&//dp_MESSAGE/@Client_Number=' + ClientNumber
+ '&//dp_MESSAGE/@Version=&//dp_MESSAGE/REQUEST/Turnaround/useXSL=true&//dp_MESSAGE/REQUEST/Turnaround/Popup=POPUP_SMALL&//dp_MESSAGE/REQUEST/Security=' + top.getContextValue("security")
+ '&//dp_MESSAGE/REQUEST/RequestReturn=Y';
popup = ************(URL,'Ann_Test','status=1,location=0,toolbar=0,menubar=0,scrollbars=1,height=300,width=500,left=150,top=150' );
popup.focus();
}

function ViewPopup(Token,ClientNumber,AnnouncementKey,AnnouncementTypeText,AnnouncementType,RecordDate,ActionType,AnnNum)
{

var MsgID;
switch (AnnouncementTypeText)
{
case "CASH":
case "COPT":
case "PRIN":
MsgID = "DIV/DIV_VIEW_AMEND_CASH_DIVIDEND";
AnnouncementType = "10";
break;
case "INTR":
case "FIXD":
case "VARI":
case "MORT":
MsgID = "DIV/DIV_VIEW_AMEND_INTEREST_ON_BOND";
AnnouncementType = "00";
break;
case "REGI":
MsgID = "DIV/DIV_VIEW_AMEND_INTEREST_ON_BOND";
AnnouncementType = "20";
break;
case "COUP":
MsgID = "DIV/DIV_VIEW_AMEND_INTEREST_ON_BOND";
AnnouncementType = "25";
break;
case "FNMI":
MsgID = "DIV/DIV_VIEW_AMEND_INTEREST_ON_BOND";
AnnouncementType = "23";
break;
case "FNMP":
MsgID = "DIV/DIV_VIEW_AMEND_INTEREST_ON_BOND";
AnnouncementType = "24";
break;
case "GNMI":
MsgID = "DIV/DIV_VIEW_AMEND_INTEREST_ON_BOND";
AnnouncementType = "27";
break;
case "GNMP":
MsgID = "DIV/DIV_VIEW_AMEND_INTEREST_ON_BOND";
AnnouncementType = "28";
break;
case "RCSH":
MsgID = "DIV/DIV_VIEW_AMEND_REC_CASH_DIVIDEND";
AnnouncementType = "00";
break;
case "RINT":
MsgID = "DIV/DIV_VIEW_AMEND_REC_INTEREST_ON_BOND";
AnnouncementType = "00";
break;
case "RSTK":
MsgID = "DIV/DIV_VIEW_AMEND_RECURRING_STOCK_ANN";
AnnouncementType = "00";
break;
case "STOK":
case "SOPT":
MsgID = "DIV/DIV_VIEW_AMEND_STOCK_DIVIDEND";
AnnouncementType = "30";
break;
case "SPLT":
MsgID = "DIV/DIV_VIEW_AMEND_STOCK_DIVIDEND";
AnnouncementType = "40";
break;
case "RIGH":
MsgID = "DIV/DIV_VIEW_AMEND_RIGHTS_DISTRIBUTION";
AnnouncementType = "70";
break;
case "SOFF":
MsgID = "DIV/DIV_VIEW_AMEND_SPIN_OFF";
AnnouncementType = "60";
break;
}
if (MsgID > ' ')
{
var popup;
var URL;
URL = '../common/main2.jsp?//dp_MESSAGE/@Message_id=' + MsgID +
'&//dp_MESSAGE/@Token=' + Token +
'&//dp_MESSAGE/@Client_Number=' + ClientNumber +
'&//dp_MESSAGE/@Version=&//dp_MESSAGE/REQUEST/Turnaround/useXSL=true&//dp_MESSAGE/REQUEST/Turnaround/Popup=POPUP_SMALL&//dp_MESSAGE/REQUEST/AnnouncementKey=' + AnnouncementKey +
'&//dp_MESSAGE/REQUEST/RequestReturn=Y' +
'&//dp_MESSAGE/REQUEST/AnnouncementTypeText=' + AnnouncementTypeText +
'&//dp_MESSAGE/REQUEST/AnnouncementType=' + AnnouncementType +
'&//dp_MESSAGE/REQUEST/RecordDate=' + RecordDate +
'&//dp_MESSAGE/REQUEST/ActionType=' + ActionType +
'&//dp_MESSAGE/REQUEST/AnnouncementStatus=' + document.Announcement_Inquiry.ANNSTAT.value +
'&//dp_MESSAGE/REQUEST/AnnouncementNum=' + AnnNum;
popup = ************(URL,'Ann_Test','status=1,location=0,toolbar=0,menubar=0,scrollbars=1,height=630,width=1200,left=50,top=50') ;
popup.focus();
}
else
{
alert("This feature is yet to be implemented");
}

}
function SetAnnouncementStatus()
{
removeAllOptions(document.Announcement_Inquiry.ANNSTAT);
if(document.Announcement_Inquiry.ANNTYPE.value == '')
{
addOption(document.Announcement_Inquiry.ANNSTAT,"", "All");
addOption(document.Announcement_Inquiry.ANNSTAT,"P", "Primary");
addOption(document.Announcement_Inquiry.ANNSTAT,"I", "Secondary");
}

addOption(document.Announcement_Inquiry.ANNSTAT,"T", "Pending - All");
addOption(document.Announcement_Inquiry.ANNSTAT,"A", "Pending - Taken off");
addOption(document.Announcement_Inquiry.ANNSTAT,"B", "Pending - Booking");
addOption(document.Announcement_Inquiry.ANNSTAT,"S", "Pending - Booking Stopped");
addOption(document.Announcement_Inquiry.ANNSTAT,"R", "Pending - Reinvestment");
addOption(document.Announcement_Inquiry.ANNSTAT,"E", "Pending - Exceptions");
addOption(document.Announcement_Inquiry.ANNSTAT,"D", "Adjustment - Today");
addOption(document.Announcement_Inquiry.ANNSTAT,"J", "Adjustment - All");
if(document.Announcement_Inquiry.CXLELIGSW.value == 'Y')
{
addOption(document.Announcement_Inquiry.ANNSTAT,"C", "Cancel Eligible");
}
}
function removeAllOptions(selectbox)
{
var i;
for(i=selectbox.options.length-1;i>=0;i--)
{
selectbox.remove(i);
}
}
function addOption(selectbox, value, text )
{
var optn = document.createElement("OPTION");
optn.text = text;
optn.value = value;
selectbox.options.add(optn);
}

function enableScreen()
{
document.Announcement_Inquiry.CLEAR.disabled = false;
document.Announcement_Inquiry.SEARCH.disabled = false;
document.getElementById("PREV").disabled = false;
document.getElementById("NEXT").disabled = false;
document.getElementById("ADDANN").disabled = false;
}
function disableScreen()
{
document.Announcement_Inquiry.CLEAR.disabled = true;
document.Announcement_Inquiry.SEARCH.disabled = true;
document.getElementById("PREV").disabled = true;
document.getElementById("NEXT").disabled = true;
document.getElementById("ADDANN").disabled = true;
}

function deriveAnnTyp(AnnouncementTypeText)
{
var AnnouncementType;
switch (AnnouncementTypeText)
{
case "CASH":
case "COPT":
case "PRIN":
AnnouncementType = "10"
break;
case "INTR":
case "FIXD":
case "VARI":
AnnouncementType = "20"
break;
case "MORT":
AnnouncementType = "23"
break;
case "REGI":
AnnouncementType = "20"
break;
case "COUP":
AnnouncementType = "25"
break;
case "FNMI":
AnnouncementType = "23"
break;
case "FNMP":
AnnouncementType = "24"
break;
case "GNMI":
AnnouncementType = "27"
break;
case "GNMP":
AnnouncementType = "28"
break;
case "RCSH":
AnnouncementType = "10"
break;
case "RINT":
AnnouncementType = "20"
break;
case "RSTK":
AnnouncementType = "30"
break;
case "STOK":
case "SOPT":
AnnouncementType = "30"
break;
case "SPLT":
AnnouncementType = "40"
break;
case "RIGH":
AnnouncementType = "70"
break;
case "SOFF":
AnnouncementType = "60"
break;
}
top.setContextValue("AnnType",AnnouncementType);
}

function deriveCxlInd(AnnouncementStatus)
{
var CxlInd;
if(document.Announcement_Inquiry.ANNSTAT.value == 'C')
{
CxlInd = "Y"
}
else
{
CxlInd = ""
}
top.setContextValue("CxlCorrectionInd",CxlInd);
}

function MSDPopUp(Token,ClientNumber)
{
spawnWindow("../common/main2.jsp?//dp_MESSAGE/@Message_id=MSD/MSD_DETAILINQUIRY" +
"&//dp_MESSAGE/@Token=" + Token +
"&//dp_MESSAGE/@Client_Number=" + ClientNumber +
"&//dp_MESSAGE/@Version=&//dp_MESSAGE/REQUEST/Turnaround/Popup=POPUP_SMALL" +
"&//dp_MESSAGE/REQUEST/RequestReturn=Y" +
"&//dp_MESSAGE/REQUEST/Security/Symbol=" + top.getContextValue("security"),
"MSDLookup","status=1,location=no,toolbar=no,menubar=no,scrollbars=yes,height=550,width=800");

}
function SRPopUp()
{
if (document.Announcement_Inquiry.RADIOSELECTED.value == "N")
{
top.setContextValue("security",document.Announcement_Inquiry.SECURITY1.value);
}
top.setContextValue("NewDivReturn","BPSDVAS");
top.ExecCode ("BPSSINR");
top.DisplayMenuForCode ("BPSSINR");

}
function Help(Token,ClientNumber)
{
spawnWindow('../common/main2.jsp?//dp_MESSAGE/@Message_id=HELP/announcement_summary' +
'&//dp_MESSAGE/@Token=' + Token +
'&//dp_MESSAGE/@Client_Number=' + ClientNumber +
'&//dp_MESSAGE/@Version=&//dp_MESSAGE/REQUEST/Turnaround/Popup=POPUP_SMALL' +
'&//dp_MESSAGE/REQUEST/RequestReturn=Y',
'HelpLookup','status=1,location=no,toolbar=no,menubar=no,scrollbars=yes,height=550,width=800');

}
function AmendReinvestStatus(Token,ClientNumber,AnnouncementKey)
{
var popup;
var URL;
URL = '../common/main2.jsp?//dp_MESSAGE/@Message_id=DIV/DIV_VIEW_AMEND_REINVESTMENT_STATUS' +
'&//dp_MESSAGE/@Token=' + Token +
'&//dp_MESSAGE/REQUEST/Turnaround/useXSL=true' +
'&//dp_MESSAGE/@Client_Number=' + ClientNumber +
'&//dp_MESSAGE/@Version=&//dp_MESSAGE/REQUEST/Turnaround/Popup=POPUP_SMALL' +
'&//dp_MESSAGE/REQUEST/RequestReturn=Y' +
'&//dp_MESSAGE/REQUEST/AnnouncementKey=' + AnnouncementKey +
'&//dp_MESSAGE/REQUEST/ScreenTypeIndicator=P' +
'&//dp_MESSAGE/REQUEST/ActionType=V';
popup = ************(URL,'AmendReinvestStatus','status=1,location=no,toolbar=no,menubar=no,scrollbars=yes,height=280,width=950,l eft=50,top=50');
popup.focus();

}*********>














Security Announcement Type Security Type Date Type Date Recurring Announcement Status







Announcement Summary





Det Sel Security Symbol Desc Tax Ann Type Rate Cur Ex Date Rec Date Pay Date Rein Elig Rein Status Vendor Booking Ann Status Act/Inv








Message : PLEASE PROVIDE SECURITY OR DATE IN SEARCH

******** language="JavaScript">
document.getElementById("SECURITY").focus();

if (document.Announcement_Inquiry.ERRORFIELD.value != "" )
{
document.getElementById(document.Announcement_Inquiry.ERRORFIELD.value).focus();
document.getElementById(document.Announcement_Inquiry.ERRORFIELD.value).style.color="red";
}

enableScreen();
if (document.Announcement_Inquiry.ErrorCode.value == "9911")
{
disableScreen();
alert("SESSION EXPIRED. PLEASE RE-LOGIN");
}
*********>





I am not able to get data and send data to a text field in above second frame with button name "search" and cann't get search data after searching.