We have an Excel workbook with macros to manipulate files on a Windows
server. The Excel workbook is accessed on a user's workstation. Everything
worked fine under Windows Server 2000. We have rebuilt the server with
Windows Server 2003. Now when the macro tries to delete files from the
server, it gets a "permission denied" error. The user has full control
permission in the folders and can manually delete the files. The current
hypothesis is that there is a setting in Server 2003 that is defaulted
differently from Server 2000, but we don't what setting this might be.
The macro uses the Scripting library and loops through the files in a folder
and uses the Delete method. The user has the option of archiving the files,
in which case the files are moved rather than deleted. The Move method works
but the Delete method doesn't.