Re: Script works on WinXp & win98 but not Win2000

"for some reason" is not good enough.

If you need assistance, please provide an error message and/or a better description of the symptoms.

You have a good start here, since you have posted the code, and your code does include some reasonable error-checking - how about posting the messages produced. Look at the event log, and the IIS log.

Also, you need to be aware that your problem is most like not perl-related, and hence is off-topic here. There is a fairly high tolorence of off-topic stuff here, but try to provide sufficient info so the subject can be closed rapidly.

Comment on Re: Script works on WinXp & win98 but not Win2000

Replies are listed 'Best First'.
Re: Re: Script works on WinXp & win98 but not Win2000 by Jargo (Initiate) on Oct 10, 2003 at 15:11 UTC
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	[reply]

Replies are listed 'Best First'.

Re: Re: Script works on WinXp & win98 but not Win2000
by Jargo (Initiate) on Oct 10, 2003 at 15:11 UTC

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

[reply]