This may not seem like a Perl problem but I need to get this part to work to help Perl automate one of my other tasks. So for those who know how to add form fields to a URL to make it work with that data I need your help!

My problem exists with an excel HTML document that has the EXPORT feature (some of you may be familiar with it). I have 200 reports to export from 200 links. I want to automate the process but I need to be able to change the URL for it to autoexport it if I typed in the URL that activated that part of the form.

The parts of the page conist of.. 

<SCRIPT language="VBScript">
Public Const sG = "False"
    
Sub ExportReport
    ' Export the form by re-calling this page with export=yes
    document.frmReport.Action="/smsreporting_serv1/Report.asp?ReportID
+=93&computername=pcname" 

    document.frmReport.export.value="yes"
    document.frmReport.submit
End Sub

.
.
<FORM name=frmReport method="get" action="report.asp" style="margin-to
+p: 0px; margin-bottom: 0px" 

tabindex=-1>

<INPUT type="hidden" name="Export">
<!-- export the data to a file --> (this is the last of the HTML

[download]
For reference, the URL I use to launch the excel page is http://stpap24/smsreporting_serv1/Report.asp?ReportID=93&computername=pcname and this URL is what I want to try to break so I can just launch the export feature automatically. Ie: http://stpap24/smsreporting_serv1/Report.asp?ReportID=93&computername=pcname&Exp­ort=1 (tried that, didn't work). I don't know what all it's looking for.

Can someone help?

In reply to For all you form "breakers" by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.