Permissions for IUSR to save an Excel file

From: Peter Krickner (peter.krickner@elicit.se)
Date: 11/27/02 

From: "Peter Krickner" <peter.krickner@elicit.se>
Date: Wed, 27 Nov 2002 10:31:14 +0100

I have a permissions problem regarding IUSR_<computername> and Excel.
I'm not sure I'm searching for the answer in the right place but hopefully
you can help me.

Webserver is IIS 5 and installed Excel version is 2000.
I would like to make it possible for a user to initiate an update of an
Excel file from an ASP interface.

In DCOM Config the identity is set to Launching user for the Excel
application.
IUSR_computername har access- and launch permissions to the excel
application.

When the web-user initiates the update, a dll written in VB is called and it
opens the Excel file and updates it with values I fetch from a database.

So far so good.
Everything works, but when it comes to saving the Excel file, I recieve an
error saying "Document not saved", error number 1004.

I'm certain this is a permissions issue since it works fine if I add IUSR to
the local administrator group on the webserver. But I do not wish to have it
that way.
The taskmanager tells me during update that it is in fact IUSR that is
executing Excel, so it's not a matter of mistaken identities.

The IUSR also has full control of the directory where the Excel file is
situated as well as to the Excel file itself.

I'm out of ideas, can someone please help me?

Regards,

/ Peter

Relevant Pages

  • Re: Running Excel Addin from VBA in Access....HELP!!
    ... You initially build a macro in Excel to do what you want, ... imbeds it in an Excel file of your choosing, then runs it as a macro. ... code that creates an Excel file, ... Dim objUniqueTeams As Object ...
    (microsoft.public.access.modulesdaovba)
  • Changing file permissions when saving Word or Excel documents
    ... Office (Word, Excel, etc.). ... Word or Excel file which is on a ... network drive with multiple user and group permissions, ... Office:Mac save command which strips write permissions on save? ...
    (microsoft.public.mac.office)
  • Re: Real Workaround for Excel Link Bug in 2007?
    ... you'd need the Excel file in the local directory. ... Or did you mean local HDD vs "the same directory as the PPT itself"? ...
    (microsoft.public.powerpoint)
  • Re: Import same Excel ranges from many workbooks
    ... Import Data from that EXCEL File via TransferSpreadsheet" in your suggested ... Dim strTable As String, strBrowseMsg As String ... accept the named ranges from those Excel workbooks without errors. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Importing data from Excel 2003 to Access 2003
    ... On which code step does the debugger highlight for the "object/class" error? ... Dim strPathFile As String, strFile As String, strPath As String ... ' Change this next line to True if the first row in EXCEL worksheet ... in the rest) of an Excel file and puts the data in an Access table. ...
    (microsoft.public.access.externaldata)