ASP input and EXCEL

A

anon1m0us

Hi;
I am waaayyy new at ASP so I am hopping someone can help me. I wrote
an ASP that accepts input from a user. I need the input saved in
different cells in an excel sheet. Everytime someone hits Submit, it
should go to a new row.
The code below shows how I want the form set up. I have no clude on
how to get the input and save it on a server's D:\Drive. ANy help is
greatly appreciated!!!!


<FORM NAME="ServerRequest.asp" ACTION="ServerRequest.asp"
METHOD="POST" >
<TABLE>
<TR>

<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>1. Please Enter your
Name: </SPAN></TD></b>
<TD><B><B>
<input type="text" name="Respondent">
</B></B></TD>
</TR>
<TR>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>2. What Project is
this for?:</SPAN></TD></b>
<TD><B>
<input type="text" name="BusinessUnitSponser">
</B></TD>

</TABLE>
<TABLE>
<tr>
<TR>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>3. Please enter the
remote access applications needed for this VM Guest Servers:</SPAN></
TD></b>
<TD><B>
<BR>
<FORM NAME="multiselectform" METHOD="post" ACTION="multiselect.asp">
<SELECT NAME="RAccess" MULTIPLE SIZE="3">
<OPTION VALUE="RDP">RDP</OPTION>
<OPTION VALUE="Timbuktu">Timbuktu</OPTION>
<OPTION VALUE="Console">Console</OPTION>
</SELECT>
<br>
</Table>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>4. Please select the Operating System
for this VM Guest Servers:</SPAN></TD></b>
<TD><B>
<BR>

<form action="">
<select name="OS">
<option value="Deafult">Select One</option>
<option value="XP">Windows XP Professional</option>

<option value="win2k3">Windows 2003 Standard</option>
<option value="win2k3web">Windows 2003 Web Server</option>
</select>
</form>
</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>5. Please enter the amount of RAM is
required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TD><B><B>
<input type="text" name="RAM">
</B></B></TD>


</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>6. Please enter the amount of HardDisk
is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TD><B><B>
<input type="text" name="RAM">
</B></B></TD>


</TD></B>
</tr>
</tbody>
</TABLE>


</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>7. Please enter the permissions that
is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=permissions rows=10 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>



<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>8. Please select the enviornment for
this VM Guest Servers:</SPAN></TD></b>
<TD><B>
<BR>

<form action="">
<select name="Enviorn">
<option value="Default">Select One</option>
<option value="POC">POC</option>
<option value="TEST">TEST (QA)</option>
<option value="DEV">DEVELOPMENT</option>
<option value="STG">STAGING</option>

</select>
</form>
</TD></B>
</tr>
</tbody>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>9. Please enter the Application/
Service Name that is required for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=Application rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>10. Please provide a Brief Description
for the use of the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=description rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>
<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>11. Please provide any platform
dependencies for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=independency rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>12. Please provide any external
dependencies for the Guest Servers: </SPAN></TD></b>
<TD><B>
<TR align=left>
<TD>&nbsp;</TD>
<TD colSpan=7>
<TEXTAREA name=exdependency rows=5 cols=50></
TEXTAREA>
</TD>
</TR>
</TABLE>

<BR>
<TABLE>
<TD>&nbsp;</TD>
<TD><SPAN class=StandardText><b>13. Please enter the length of time
that is required for the life of the Guest Servers: </SPAN></TD></
b><BR>
<TD><B>
<BR>
<TD><B><B>
<input type="text" name="LifeCycle">
</B></B></TD>
</TABLE>
<BR><BR>
<input type="submit" value="Submit">
<input type="reset" value="Reset">

</FORM>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top