About Us

[email protected]

Hi,

I am attempting to retrieve employee information from my company's web
site (employee directory). The web page uses frames (I think). Working
directly from the web page, you enter data on the form, select the
search field (eg. empl. name, ID, phone number, etc.) to return the
results.

I am attempting to retrieve the employee name based on the employee ID
which i already have stored as a variable in Excel.

I am getting better at coding in Excel, but this is new ground for me
and any help would be appreciated. I would like to bring the emloyee
name back to a cell within Excel.

I have pasted the code from the intranet "search frame" below.
Regardless of the search criteria, the search results are always listed
in a set order (e.g. name, id, phone, dept., etc.) Thanks in advance
for any responses.

Alan

<html
<head
<titleEmployee Directory</title
<LINK rel="stylesheet" type="text/css" href="/css/mycompany.css"
</head

<SCRIPT LANGUAGE="JavaScript"
<!--
var w2 = null;
function IHRISHelp(){
if (w2 != null)
w2.close();

w2=window.open("help.htm",
"Help","width=400,height=300,navbar=yes,resizable= yes");

}

function submitTheForm(){
if (document.form0.searchval.value.length 0) {
document.form0.submit();
}
}

function MainNumbers(){
if (w2 != null)
w2.close();
w2=window.open("mainnumbers/MainNumbers.htm",
"MainNumbers","width=600,height=350,scrollbars=yes ,menubar=yes,navbar=yes,resizable=yes");
}

function LeadershipTeamReport(){
if (w2 != null)
w2.close();
w2=window.open("LeadershipTeamReport/LeadershipTeamReport.xls",
"LeadershipTeamReport","width=600,height=350,scrol lbars=yes,menubar=yes,navbar=yes,resizable=yes");
}

function PrintEmployeeList(){
parent.EmployeeList.focus();
parent.EmployeeList.print();
}
//--
</SCRIPT

<body class="body5" onLoad="document.forms[0].searchval.focus();"

<h3Employee Directory</h3

<form method="POST" action="listingFrame.asp" target="EmployeeList"
name="form0"
<table border="0"

<tr
<tdSearch For:<input type="text" name="searchval" size="20"
onKeyUp="submitTheForm()"</td
<td align='left' valign='center'Search By:
<select name="Search_Field" size="1"
<option VALUE="Name"Name</option
<option VALUE="Empnum"Empl. Number</option
<option VALUE="Phone"Phone Extension</option
<option VALUE="Mail"Mail</option
<option VALUE="BusinessUnit"Organization</option
<option VALUE="Department"Department/Area</option
<option VALUE="Job"Job Title</option
<option VALUE="SupervisorName"Manager</option
<option VALUE="Phonetic"Phonetic Last Name</option
</SELECT</td
</tr</table
<table border="0" width="100%"
<tr
<td
<input type="submit" value="Search" name="Submit" 
<input type="button" value="Print" name="Print"
onclick="PrintEmployeeList();" 
<input type="submit" value="Export" name="Submit" 
<!--<input type="button" value="Main Numbers" name="Main"
onclick="MainNumbers();" --
</td
</tr
</table
<input type="hidden" name="appType" value="full"
<hr
</form

</body

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Importing data over intranet	creativeops	Excel Discussion (Misc queries)	0	May 22nd 06 11:43 PM
need macro to page break between company names automatically	Ms Magers	Excel Programming	2	May 4th 06 04:50 PM
pull data for a company with data in diff cells multiple wrkshts	kcoachbiggs	Excel Worksheet Functions	0	March 8th 06 09:24 PM
Design Q: XL XP, 97 and multiple users submitting data over intranet	Keith R[_3_]	Excel Programming	0	November 5th 03 09:44 PM
How to get data from Access Database in Intranet	Bill Li	Excel Programming	1	July 10th 03 07:04 AM

Menu

About Us