VBA Code to paste cell values into web form

F

frenchie

New Member
Joined
Sep 3, 2008
Messages
5
I have a CSV file which contains employee data. There are 8 colums and 120 rows. I only need to copy the values from 4 of the columns (FirstName, LastName, EmployeeID and PhoneNumber) into a web form (text boxes) which holds 10 employees. How can I copy 10 rows of data to the web form and submit it and then do the next 10, etc using VBA.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
The form I will be pasting to is on a secured server but I pulled the data from between the form tags as shown below. I hope this is what you require.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Sign Up 10 People</title>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

<table width="640" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<tr> </tr>
<td><h4><a name="signup" id="signup" </a><strong>Please complete fields</strong>

</h4>
<form action="/members/signup10.php" method="post" name="form" id="form">
<table border="1" width="100%" align="center" cellpadding="4" cellspacing="0" >
<tr>
<td width="203">First Name:</td>
<td width="425"><input size="10" maxlength="32" name="fname1" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname1" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid1" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone1" type="text" /><strong>digits only eg: 1112223333 </strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name:</td>
<td ><input size="10" maxlength="32" name="fname2" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname2" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid2" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone2" type="text" /><strong>digits only eg: 1112223333 </strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name:</td>
<td ><input size="10" maxlength="32" name="fname3" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname3" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid3" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone3" type="text" /><strong>digits only eg: 1112223333</strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name:</td>
<td ><input size="10" maxlength="32" name="fname4" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname4" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid4" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone4" type="text" /><strong>digits only eg: 1112223333 </strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name:</td>
<td ><input size="10" maxlength="32" name="fname5" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname5" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid5" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone5" type="text" /><strong>digits only eg: 1112223333</strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name:</td>
<td ><input size="10" maxlength="32" name="fname6" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname6" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid6" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone6" type="text" /><strong>digits only eg: 1112223333</strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name:</td>
<td ><input size="10" maxlength="32" name="fname7" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname7" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid7" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone7" type="text" /><strong>digits only eg: 1112223333</strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name:</td>
<td ><input size="10" maxlength="32" name="fname8" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname8" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid8" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone8" type="text" /><strong>digits only eg: 1112223333</strong></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name:</td>
<td ><input size="10" maxlength="32" name="fname9" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname9" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid9" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone9" type="text" /><strong>digits only eg: 1112223333</strong></td>
</tr>

<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>First Name:</td>
<td ><input size="10" maxlength="32" name="fname10" type="text" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><input size="16" maxlength="48" name="lname10" type="text" /></td>
</tr>
<tr>
<td>Employee ID:</td>
<td><input size="14" maxlength="40" name="empid10" type="text" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><input size="12" maxlength="20" name="phone10" type="text" /><strong>digits only eg: 1112223333 </strong></td>
</tr>
<tr>
<td colspan=2 align="center"> <input name="btnsave" value="Save Edits" type="submit" /></td>
</tr>
</table>
</form></td></tr>
</table>
</body>
</html>


The following is a partial list of the CSV file:

fname lname empid dist. postal phone
John Mabley 10587A AT T9E 4T5 7808131041
Mary Dore 12547B BA T6P 1X2 7804565321
Marg Shaul 15587B BA T5Y 6G4 4038736721
Rene Clark 17368B BA T6K 2T9 8315950088
Eric Lowes 18332B BA T6J 6G2 7074359111
Rhonda Emery 12587D DR T2E 0B3 2163417249
Ted Hutches 13589D DR T1H 0A2 3603338622
Jerry Hart 15897D DR T1H 0A2 4043639128
Robert Mcgee 16472D DR T1J 4P2 8049650857
Joyce Sharman 17542D DR T2E 9C6 4805950570
Jeffrey Shipley 12669H HL T8S 1M5 8605822224
Ronald Jones 13597H HL T8S 1M4 6612964721
George Navarro 10689L LR T2E 0B2 3155975394
Jimmy Manns 14448L LR T4R 3R1 3524287262
James Cantell 16223L LR T4R 0K7 6163897768
Ayla Ruf 11938M MD T2E 3C7 2062974888
Matt Stewart 15822M MD T2N 0C7 7145830041
Gerald Padilla 16969M MD T2N 0C7 8057665153
Cambria Adams 17444M MD T2N 0B3 5417823222
Kim Allen 19635M MD T2N 0B3 9528189323
Brian Dye 10118S SR T2E 7P3 5087880201
Mike Bloke 13424S SR T2K 0W6 9517769931
Kim Becker 14888S SR T2G 5T3 2095131110

Thanks
 
Upvote 0
Sorry about that! Let's try this again.

The form I will be pasting to is on a secured server but I pulled the data from between the html tags as shown below. I hope this is what you require.


HTML: 
 <title>Sign Up 10 People</title>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="640" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td><h4><a name="signup" id="signup"></a><strong>Please Fill In Fields</strong>
      
      </h4>
          <form  action="/members/signup10.php" method="post" name="form" id="form">
            <table border="1" width="100%" align="center" cellpadding="4" cellspacing="0" >
              <tr>
                <td width="203">First Name:</td>
                <td width="425"><input size="10" maxlength="32" name="fname1" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname1" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid1" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone1" type="text" /></td>
              </tr>
              <tr>
                <td> </td>
                <td> </td>
              </tr>
              <tr>
                <td>First Name:</td>
                <td ><input size="10" maxlength="32" name="fname2" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname2" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid2" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone2" type="text" /></td>
              </tr>
              <tr>
                <td> </td>
                <td> </td>
              </tr>
              <tr>
                <td>First Name:</td>
                <td ><input size="10" maxlength="32" name="fname3" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname3" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid3" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone3" type="text" /></td>
              </tr>
              <tr>
                <td> </td>
                <td> </td>
              </tr>
              <tr>
                <td>First Name:</td>
                <td ><input size="10" maxlength="32" name="fname4" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname4" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid4" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone4" type="text" /></td>
              </tr>
              <tr>
                <td> </td>
                <td> </td>
              </tr>
              <tr>
                <td>First Name:</td>
                <td ><input size="10" maxlength="32" name="fname5" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname5" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid5" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone5" type="text" /></td>
              </tr>
              <tr>
                <td> </td>
                <td> </td>
              </tr>
              <tr>
                <td>First Name:</td>
                <td ><input size="10" maxlength="32" name="fname6" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname6" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid6" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone6" type="text" /></td>
              </tr>
              <tr>
                <td> </td>
                <td> </td>
              </tr>
              <tr>
                <td>First Name:</td>
                <td ><input size="10" maxlength="32" name="fname7" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname7" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid7" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone7" type="text" /></td>
              </tr>
              <tr>
                <td> </td>
                <td> </td>
              </tr>
              <tr>
                <td>First Name:</td>
                <td ><input size="10" maxlength="32" name="fname8" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname8" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid8" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone8" type="text" /></td>
              </tr>
              <tr>
                <td> </td>
                <td> </td>
              </tr>
              <tr>
                <td>First Name:</td>
                <td ><input size="10" maxlength="32" name="fname9" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname9" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid9" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone9" type="text" /></td>
              </tr>
              
              <tr>
                <td> </td>
                <td> </td>
              </tr>
              <tr>
                <td>First Name:</td>
                <td ><input size="10" maxlength="32" name="fname10" type="text" /></td>
              </tr>
              <tr>
                <td>Last Name:</td>
                <td><input size="16" maxlength="48" name="lname10" type="text" /></td>
              </tr>
              <tr>
                <td>Employee ID:</td>
                <td><input size="14" maxlength="40" name="empid10" type="text" /></td>
              </tr>
              <tr>
                <td>Phone:</td>
                <td><input size="12" maxlength="20" name="phone10" type="text" /></td>
              </tr>
              <tr>
                <td colspan=2 align="center"> <input name="btnsave" value="Save Info" type="submit" /></td>
              </tr>
            </table>
        </form></td></tr>
  </table>
</body>


The following is a partial list of the CSV file:

fname,lname,empid,dist,postal,phone
John,Mabley,10587A,AT,T9E 4T5,7808131041
Mary,Dore,12547B,BA,T6P 1X2,7804565321
Marg,Shaul,15587B,BA,T5Y 6G4,4038736721
Rene,Clark,17368B,BA,T6K 2T9,7805950088
Eric,Lowes,18332B,BA,T6J 6G2,7804359111
Rhonda,Emery,12587D,DR,T2E 0B3,4033417249
Ted,Hutches,13589D,DR,T1H 0A2,4033338622
Jerry,Hart,15897D,DR,T1H 0A2,4033639128
Robert,Mcgee,16472D,DR,T1J 4P2,4039650857
Joyce,Sharman,17542D,DR,T2E 9C6,4035950570
Jeffrey,Shipley,12669H,HL,T8S 1M5,7805822224
Ronald,Jones,13597H,HL,T8S 1M4,7802964721
George,Navarro,10689L,LR,T2E 0B2,7805975394
Jimmy,Manns,14448L,LR,T4R 3R1,7804287262
James,Cantell,16223L,LR,T4R 0K7,7803897768
Ayla,Ruf,11938M,MD,T2E 3C7,7802974888
Matt,Stewart,15822M,MD,T2N 0C7,7805830041
Gerald,Padilla,16969M,MD,T2N 0C7,7807665153
Cambria,Adams,17444M,MD,T2N 0B3,7807823222
Kim,Allen,19635M,MD,T2N 0B3,7808189323
Brian,Dye,10118S,SR,T2E 7P3,4037880201
Mike,Bloke,13424S,SR,T2K 0W6,4037769931
Kim,Becker,14888S,SR,T2G 5T3,4035131110

Thanks
 
Upvote 0
Try this:

Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = True
.navigate www.yoursite.com
Do Until .readystate = 4
DoEvents
Loop
Set mytextfield1 = .document.all.Item("fname1")
mytextfield1.Value = Sheets("sheet2").Range("a1").Value
IE.document.forms("form").submit
End With
End Sub

This will only work for the very first field. Try this and see if it works, if not we can try something else.<!-- / message -->
 
Upvote 0
Hi BSteves,

It worked great for the first field in the form. I had to change what you see in red below to make it work.

Sub Fill_Form()
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = True
.navigate URL:="https://www.mysite.com/signup10.htm"
Do Until .readystate = 4
DoEvents
Loop
Set mytextfield1 = .document.all.Item("fname1")
mytextfield1.Value = Sheets("test_vba").Range("a1").Value
IE.document.forms("form").submit
End With
End Sub

What are the next steps I have to take to make it loop through 10 rows from the csv file, submit the data and then do the next 10 in the csv file until it reaches the end?

Thanks
 
Upvote 0
Before the submit part of the code you will have to add as many as these as you need. fname1 and a1 will change. Look at your source code and find <td><input size="16" maxlength="48" name="lname1" type="text" /></td>
</tr>

Set mytextfield1 = .document.all.Item("lname1")
mytextfield1.Value = Sheets("test_vba").Range("b1").Value
 
Upvote 0
Found this post very helpful but having some issues replicating for my own use. Was hoping to get some help. Trying to Paste information from an excel cell to a webform then submit (unit rate target). This is the code:

Option Explicit
'Requires Microsoft Internet Controls Reference Library
Dim WithEvents ie As InternetExplorer
Sub TUR()
Set ie = CreateObject("InternetExplorer.Application")
With ie
.Visible = True
.Navigate URL:="https://abe2-portal.amazon.com/gp/picking/config/processPaths.html?action=edit&processPathName=PPMultiLargePrem"
Do Until ie.ReadyState = READYSTATE_COMPLETE
DoEvents
Loop
Set mytextfield7 = .Document.all.Item("unitRateTarget")
mytextfield7.Value = Sheets("Ops Planner").Range("p21").Value
ie.Document.forms("form").Submit
End With
End Sub

The website is company but was able to copy the source which is:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<html><o:p></o:p>
<o:p></o:p>
<head><o:p></o:p>
****** http-equiv="Content-Type" content="text/html; charset=UTF-8"><o:p></o:p>
<o:p></o:p>
****** HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE"><o:p></o:p>
****** HTTP-EQUIV="PRAGMAS" CONTENT="NO-CACHE"><o:p></o:p>
****** HTTP-EQUIV="Expires" CONTENT="-1"><o:p></o:p>
<link rel="stylesheet" href="/gp/common/FCStyle.css" type="text/css" ><o:p></o:p>
<link rel="stylesheet"<o:p></o:p>
type="text/css" href="/gp/common/stripe.css" ><o:p></o:p>
******** type="text/javascript"<o:p></o:p>
src="https://internal-cdn.amazon.com/btk.amazon.com/ajax/libs/jquery/1.5.2/jquery.min.js">*********><o:p></o:p>
******** type="text/javascript"<o:p></o:p>
src="https://internal-cdn.amazon.com/is-it-down.amazon.com/javascripts/stripe.min.js">*********><o:p></o:p>
<o:p></o:p>
<title><o:p></o:p>
<o:p></o:p>
ABE2-Picking Configuration<o:p></o:p>
</title><o:p></o:p>
<o:p></o:p>
</head><o:p></o:p>
<body><o:p></o:p>
<div id="top"><o:p></o:p>
<o:p></o:p>
<div class="title" style="float: left;"><o:p></o:p>
<a href="/gp/common/Welcome.html" alt="links to main console welcome page">FC Console</a><o:p></o:p>
</div><o:p></o:p>
<o:p></o:p>
<table border="0" cellpadding="0" cellspacing="0" style="margin: 0; float: right"><o:p></o:p>
<tr><o:p></o:p>
<td class="consoleinfo">ABE2</td><o:p></o:p>
<td class="consoleinfo">Tue Apr 10 09:35:03 2012</td><o:p></o:p>
<td class="userinfo"><o:p></o:p>
Hello Lloyd Darius St. Rose <a href="https://w.amazon.com/?Kerberos_Sign_Out">(Sign Out)</a><o:p></o:p>
</td><o:p></o:p>
<td class="userinfo">Employee info:<o:p></o:p>
<form action="https://fclm-portal.amazon.com/employee/timeDetails" method="GET" class="userinfo"><o:p></o:p>
<input type="text" name="employeeId" size="9" maxlength="8" /><o:p></o:p>
<input type="hidden" name="warehouseId" value="ABE2"/><o:p></o:p>
</form><o:p></o:p>
</td><o:p></o:p>
<td class="userinfo"><a href="http://abe2-portal.amazon.com/gp/picking/config/processPaths.html?ConsolePrintable=foo&action=edit&processPathName=PPMultiABMedium">Print</a></td><o:p></o:p>
</tr><o:p></o:p>
</table><o:p></o:p>
<ul class="nav root-unselected0"><o:p></o:p>
<li><a class="noborder" href="https://fcmenu.amazon.com/ABE2" target="_top">Web Menu</a></li><o:p></o:p>
<li><a href="/gp/labor-management/Welcome.html" target="_top">Labor Mgmt</a></li><o:p></o:p>
<li><a href="/gp/aquas/Welcome.html" target="_top">Aquas</a></li><o:p></o:p>
<li><a href="/gp/inventory/Welcome.html" target="_top">Inventory</a></li><o:p></o:p>
<li><a href="/gp/cycle-count/Welcome.html" target="_top">Cycle Count</a></li><o:p></o:p>
<li><a href="/gp/receive/index.html" target="_top">Receive</a></li><o:p></o:p>
<li><a href="/gp/fc-inbound-prep/research/Research.html" target="_top">Inbound Prep</a></li><o:p></o:p>
<li><a href="/gp/fc-work-order/reporting/Welcome.html" target="_top">Work Order</a></li><o:p></o:p>
<li><a href="/gp/manufacturing/Welcome.html" target="_top">Manufacturing</a></li><o:p></o:p>
<li><a href="/gp/spaceman/console/summary.html" target="_top">Space Mgmt</a></li><o:p></o:p>
<li><a href="/gp/non-sortable/Welcome.html" target="_top">Non-Sortable</a></li><o:p></o:p>
<li><a href="/gp/transshipment/Welcome.html" target="_top">Transshipment</a></li><o:p></o:p>
<li class="picking-color1" ><a href="/gp/picking/index.html" target="_top">Picking</a></li><o:p></o:p>
<li><a href="/gp/sortation/Welcome.html" target="_top">Sortation</a></li><o:p></o:p>
<li><a href="/gp/pack/Welcome.html" target="_top">Pack</a></li><o:p></o:p>
<li><a href="/gp/ship/Welcome.html" target="_top">Ship</a></li><o:p></o:p>
<li><a href="/gp/dock/Welcome.html" target="_top">Dock</a></li><o:p></o:p>
<li><a href="/gp/customer-returns/Welcome.html" target="_top">C. Returns</a></li><o:p></o:p>
<li><a href="/fc-cgi/planner/main.cgi" target="_top">V. Returns</a></li><o:p></o:p>
<li><a href="/gp/physical-evaluation/Menu.html" target="_top">WarehouseDeals</a></li><o:p></o:p>
<li><a href="/gp/fc-workflow/Welcome.html" target="_top">Workflow</a></li><o:p></o:p>
<li><a adminlink href="http://dc-web.amazon.com" target="_blank" target="_top">Admin</a></li><o:p></o:p>
<li><a href="/gp/remote-it-sw/Welcome.html" target="_top">Remote IT</a></li><o:p></o:p>
<li><a href="/gp/fc-application-services/Welcome.html" target="_top">Application Services</a></li><o:p></o:p>
</ul><o:p></o:p>
<o:p></o:p>
<o:p></o:p>
<div style="height: 2px;" class="nav picking-color1"></div><o:p></o:p>
<o:p></o:p>
<ul class="nav root-unselected1"><o:p></o:p>
<li><a class="noborder" href="/gp/picking/processpaths-new.html" target="_top">Process Paths</a></li><o:p></o:p>
<li><a href="/gp/picking/pickareas-new.html" target="_top">Pick Areas C4</a></li><o:p></o:p>
<li><a href="/gp/picking/pickareas-c29.html" target="_top">Pick Areas C29</a></li><o:p></o:p>
<li><a href="/gp/picking/pickzones-new.html" target="_top">Pick Zones</a></li><o:p></o:p>
<li><a href="/gp/picking/batches.html" target="_top">Batches</a></li><o:p></o:p>
<li><a href="/gp/picking/workforce.html?expandSummary=0" target="_top">Workforce</a></li><o:p></o:p>
<li><a href="/gp/picking/reports/index.html" target="_top">Reports</a></li><o:p></o:p>
<li><a href="/gp/picking/tools/aps-research.html" target="_top">Self Service Tools</a></li><o:p></o:p>
<li><a target=_blank href="https://pickinghelp.amazon.com/GuideToAPS/index.html" target="_top">APS Guide</a></li><o:p></o:p>
<li class="picking-color2" ><a class=adminlink href="/gp/picking/config/index.html" target="_top">Configuration</a></li><o:p></o:p>
</ul><o:p></o:p>
<div style="height: 1px;" class="nav picking-color2"></div><o:p></o:p>
<ul class="nav root-unselected2"><o:p></o:p>
<li><a class="noborder" href="/gp/picking/config/CollatingConfig.html" target="_top">Collating</a></li><o:p></o:p>
<li><a href="/gp/picking/config/categorization/active-categorization.html" target="_top">Categorization</a></li><o:p></o:p>
<li><a href="/gp/picking/config/processpath-configuration/processpath-categories.html" target="_top">Process Path Config</a></li><o:p></o:p>
<li><a href="/gp/picking/config/pickAreas.html" target="_top">Pick Area Properties</a></li><o:p></o:p>
<li class="picking-color3" ><a href="/gp/picking/config/processPaths.html" target="_top">Process Path Properties</a></li><o:p></o:p>
<li><a href="/gp/picking/config/pickerEligibilities.html" target="_top">Picker Eligibilities</a></li><o:p></o:p>
<li><a href="/gp/picking/config/pickAreaClusters.html" target="_top">Cluster Properties</a></li><o:p></o:p>
<li><a href="/gp/picking/config/pickerClusterEligibilities.html?mapType=AreaClusterEligibilityMap" target="_top">Cluster Eligibilities</a></li><o:p></o:p>
<li><a href="/gp/picking/config/PickSchool.html" target="_top">Pick School</a></li><o:p></o:p>
</ul><o:p></o:p>
<o:p></o:p>
<div style="height: 1px;" class="nav picking-color3"></div><o:p></o:p>
</div><o:p></o:p>
<div id="maincontent"><o:p></o:p>
<!--style type="text/css"><o:p></o:p>
td {<o:p></o:p>
font-size: 80%;<o:p></o:p>
}<o:p></o:p>
</style--><o:p></o:p>
<o:p></o:p>
<h3>Process Path Properties</h3><o:p></o:p>
<FORM METHOD=POST ACTION="processPaths.html"><o:p></o:p>
<INPUT TYPE=HIDDEN NAME="action" VALUE="update"><o:p></o:p>
<INPUT TYPE=HIDDEN NAME="processPathName" VALUE="PPMultiABMedium"><o:p></o:p>
<o:p></o:p>
<FONT SIZE=2><B>PPMultiABMedium (DefaultPicking, pkREBINLEV1)</B></FONT><P><o:p></o:p>
<o:p></o:p>
<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=1><o:p></o:p>
<TR><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Status</B></FONT></TD><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Demand Window</B></FONT></TD><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Pick Rate Ave</B></FONT></TD><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Process Pad</B></FONT></TD><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Tote Limit</B></FONT></TD><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Shipment Limit</B></FONT></TD><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Batch Limit</B></FONT></TD><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Target Unit Rate</B></FONT></TD><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Min Premium Percent</B></FONT></TD><o:p></o:p>
<TD><FONT SIZE=1 ALIGN=LEFT VALIGN=TOP><B>Min Priority</B></FONT></TD><o:p></o:p>
</TR><o:p></o:p>
<TR><o:p></o:p>
<TD><o:p></o:p>
<SELECT NAME="status"><o:p></o:p>
<OPTION VALUE="Active" SELECTED>Active</OPTION><o:p></o:p>
<OPTION VALUE="Paused" >Paused</OPTION><o:p></o:p>
<OPTION VALUE="Halt"> Halt </OPTION><o:p></o:p>
</SELECT><o:p></o:p>
</TD><o:p></o:p>
<TD><INPUT TYPE=TEXT SIZE=8 NAME="demandCompletionWindow" <o:p></o:p>
VALUE=00:00:00></TD><o:p></o:p>
<TD><INPUT TYPE=TEXT SIZE=4 NAME="pickRateAverage" VALUE=120></TD><o:p></o:p>
<TD><INPUT TYPE=TEXT SIZE=8 NAME="processingPad" VALUE=04:00:00></TD><o:p></o:p>
<TD><INPUT TYPE=TEXT SIZE=4 NAME="containerQuantityLimit" <o:p></o:p>
VALUE=0></TD><o:p></o:p>
<TD><INPUT TYPE=TEXT SIZE=6 NAME="openDemandQuantityLimit" <o:p></o:p>
DISABLED='true'<o:p></o:p>
VALUE=0></TD><o:p></o:p>
<TD><INPUT TYPE=TEXT SIZE=6 NAME="openBatchQuantityLimit" <o:p></o:p>
VALUE=6></TD><o:p></o:p>
<TD><INPUT TYPE=TEXT SIZE=6 NAME="unitRateTarget" VALUE=1200></TD><o:p></o:p>
<TD><INPUT TYPE=TEXT SIZE=8 NAME="minPremiumPercent" <o:p></o:p>
DISABLED='true'<o:p></o:p>
VALUE=-1></TD><o:p></o:p>
<TD><o:p></o:p>
<select name = "minPriority"><o:p></o:p>
<option VALUE=0 SELECTED>0 - Min Priority</option><o:p></o:p>
<option VALUE=1 >1 - Super Savers</option><o:p></o:p>
<option VALUE=4 >4 - Normal/Std</option><o:p></o:p>
<option VALUE=10 >10 - Premium</option><o:p></o:p>
<option VALUE=15 >15 - Fast Track</option><o:p></o:p>
<option VALUE=16 >16 - Same/Next</option><o:p></o:p>
</select><o:p></o:p>
</TD><o:p></o:p>
</TR><o:p></o:p>
</TABLE><o:p></o:p>
<o:p></o:p>
<INPUT TYPE=SUBMIT VALUE="Submit Changes"><o:p></o:p>
<o:p></o:p>
</FORM><o:p></o:p>
<BR><o:p></o:p>
<BR><o:p></o:p>
<FONT SIZE=2><B>Last 30 Changes to ProcessPathProperties</B></FONT><o:p></o:p>
<br/><a href="/gp/picking/reports/alarms-history.html?events=1&types=ConfigChange&apps=All">This has been replaced with the Critical Decision Log</a><o:p></o:p>
</div><o:p></o:p>
<!-- whfh-hUVfxgYZlst4LmzhprYAutcgYH66NRuaPf7JAXsFd5A= rid-1WQ7QTTHY53249EPVB58 --><o:p></o:p>
<o:p></o:p>
</body><o:p></o:p>
<o:p></o:p>
<head><o:p></o:p>
****** HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE"><o:p></o:p>
****** HTTP-EQUIV="PRAGMAS" CONTENT="NO-CACHE"><o:p></o:p>
****** HTTP-EQUIV="Expires" CONTENT="-1"><o:p></o:p>
</head><o:p></o:p>
</html><o:p></o:p>
<o:p></o:p>
******** type="text/javascript"> <o:p></o:p>
// "Is It Down?" Stripe for FC PickE<o:p></o:p>
$(function() {<o:p></o:p>
isItDownStripe('FCPickExecution', 601, 1); // dispatcher<o:p></o:p>
isItDownStripe('FCPickExecution', 602, 1); // receiver broker<o:p></o:p>
isItDownStripe('FCPickExecution', 603, 1); // dispatcher broker<o:p></o:p>
});<o:p></o:p>
*********><o:p></o:p>
PLEASE HELP!
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
VBA code to create command button and copy criteria based data from one worksheet to another
2
Replies
13
Views
456
Tupe77
T
R
  • Question
VBA code to insert blanks after two conditions
Replies
1
Views
63
Joe4
Joe4
T
  • Question
VBA code to export specific variably named tabs to new workbook?
Replies
2
Views
404
thebigejr
T
D
  • Question
getting info from web site via vba /sql
Replies
3
Views
284
dave3009
dave3009
W
  • Question
Posting Data with new form text boxes
Replies
0
Views
253
woodland81
W

Forum statistics

Threads
1,214,780
Messages
6,121,525
Members
449,037
Latest member
tmmotairi

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top