Hey all,

I'm working on a macro that can go to a webpage and login in (got that). But then I need it to select the name of a site on a dropdown box and hit submit. Then I need it to copy an entire table to a cell in my spreadsheet (it will always be 2 columns wide).

Any help would be much appreciated!


Here is the code for the drop down menu:
<form name="form1" action="">
         		    <table class="stdTable" style="width:80%">
                       <tr>
                          <td >&nbsp;&nbsp;&nbsp;&nbsp;Site:</td>
                          <td>
                             <select id="site" class="stdDropDown">
                                <option value="Select Site">Select Site</option>    <<<CHANGE THIS OPTION
                             </select>
                          </td>
                          <td >&nbsp;&nbsp;&nbsp;&nbsp;View:</td>
                          <td>
                             <select id="view" class="stdDropDown">
                                <option value="AD">All Departments</option>
                                <option value="CP">Call Processing Departments</option>
                                <option value="NC">Non Call Processing</option>
                                <option value="LO">Logged Out</option>
								
                             </select>
                          </td>
                          <td >&nbsp;&nbsp;&nbsp;&nbsp;Sort:</td>
                          <td>
                             <select id="sort" class="stdDropDown">
                                <option value="DC">Department Code</option>
                                 <option value="ES">By Employees Ascending</option>
                                <option value="ED">By Employees Descending</option>
                            </select>
                          </td>
						  <td>
                             <input TYPE="button" CLASS="button1" VALUE="SUBMIT" onClick="checkFields2();">&nbsp;&nbsp;   <<<<PRESS THIS BUTTON
						  </td>
 
                       </tr>
 
                    </table>
              </form>
And here is the code for the table that it prints out:
      </div>
      <div id="statusDiv" style="position:center; display:block;">
      </div>
      <div id="displayDiv" style="position:center; display:block;">
      </div>