in reply to Re: Win32::OLE question
in thread Win32::OLE question

Thanks for replying CountZero. Far as I can tell they are the same but I might not be checking in the right place. I right-click on the Excel icon and check properties/security. As an experiment I set everyone to full control but no difference, same error message. I think Perl is running as the IUSR account but I could be wrong there too. Anywhere else I should check permissions?

Replies are listed 'Best First'.
Re^3: Win32::OLE question
by CountZero (Bishop) on Jan 10, 2009 at 23:37 UTC
    May be have a look at the webserver and see as what user it runs? And check the configuration of the webserver to see if it might be another user if it executes external programs (such as perl.exe). Finally check both the permissions of the perl scripts and the excel-files and the directories they live in. They should all be read/write/execute allowed for the webserver.

    CountZero

    A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James