My apologies NetWallah. I realize that it might not be something inherently wrong with my "perl" code but perhaps other people had had similar problems opening excel files using the windows server. I am not sure how to get the IIS log or the event log (I mentioned before that I am a newbie at this stuff). From memory though, the first error that popped up had to do with the first macro that I run. My perl code (theoretically) adds a worksheet called "Sheet1" (by default) and puts the form data into that sheet but on my friends computer the script succeeded in creating "Sheet1" but then failed to put any of the form data into that sheet. My macros then got messed up because there was no content in Sheet1. After trying to change a few things, we ran clicked Submit again and every time I got the "Unable to Open document" error that was built into the script but it said it was opening document "0" and not the one I had written into the code.

I thought that it might at first be something in the way perl is handled on different servers or OS's but if it has strayed too far from the topics on this site, I would appreciate a nudge in the right direction to find someone who might be able to help in this. My thoughts are that it might be something set in the IIS that does not let me change that xls file or something but that is just a guess.

Thank you Andreas

In reply to Re: Re: Script works on WinXp & win98 but not Win2000 by Jargo
in thread Script works on WinXp & win98 but not Win2000 by Jargo

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.