I know I'm not using references but it was the way I had learned using functions in perl from existing code and from textbooks I had read. This line of code calls the module I had posted earlier. Basically this perl script is actually a CGI script that (initially) displays an html form whereby a user selects such things as type of report and what columns are used for the x and y axes. The form's action is set to the cgi script (so it calls itself). Once all the form elements have been checked the script can proceed calling the above module. After the call finishes the script continues to re-generate the html page with the previous data re-populating the fields and a message to tell the user the spreadsheet has been created. There is also an in-line javascript that opens a new window to display the newly created chart (basically displays the whole workbook in the new browser window). Hope this additional information helps. Appreciate the help as well. Thanks.

Rob 

$warning = &swOpenExcel($maxColumns,"FILE",$lAppName,$wbFullDirectory,
+$wbChartDirectory,$wbExcelName,$wbExcelData,
                       $dataCol,$strtRow,$labelCol,$endRow,$typeGraph,
+$ChartName,
                       $lChartTitle,$lChartCriteria[0],'JPG',$lLegendK
+ey,$lData_Labels,*returnVals,*X_Axis,*Y_Axis,*LegendVals);

[download]

20060117 Janitored by Corion: Added formatting, code tags

In reply to Re^8: Excel Win32::OLE->Uninitialize by Anonymous Monk
in thread Excel Win32::OLE->Uninitialize by rpike

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.