I don't think it is a folder permission issue. It is actually crashing on the CreateObject line of code, so it never gets a chance to access a folder or even a document for that matter.
>>Hi all,
>>
>>I am having trouble running this code on a Windows 2003 Server. When I try to run the code I get a Program Error Dialog Box:
>>Ole error code 0X80070005: Access is denied. Any help is greatly appreciated.
>>
>>
>> Local oExcel As 'Excel.application'
>> oExcel = Createobject("Excel.application")
>> oWorkbook=oExcel.workbooks.Add()
>>
>Do you have permitions to create/read/write files in that folder?
James Harvey, MCP
Memphis Police Department
225 Channel Three DR
Memphis, TN 38103
901 577-1296