Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can not save spreadsheet from a windows service on windows server
I have a service app that create excel spreadsheet automatically. this worked
on xp and windows server 2003. but now i need it work on windows server 2008. When the service run to this line: _workBook.SaveAs(excelPhysicalFilePath,Excel.XlFil eFormat.xlWorkbookNormal,null,null,false,false,Exc el.XlSaveAsAccessMode.xlExclusive,false,false,null ,null,null) ; it always returns error "System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC" however, I also has an windows form test app which runs exact same code, but it works. So i wonder maybe the error is related to some new restriction implemented for service/DCOM in windows server 2008, can somebody give me some idea how to solve it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can not save spreadsheet from a windows service on windows server
Is it permissions? Your service will either be running under the Local
System account, or you will have specified it to use another account. If it is running under Local System then try assigning another username to it (in the Services applet in Administrative Tools). Alternatively, is excelPhysicalFilePath pointing at a mapped drive? Mapped drived do not exist from a service's perspective. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "dragonemp" wrote: I have a service app that create excel spreadsheet automatically. this worked on xp and windows server 2003. but now i need it work on windows server 2008. When the service run to this line: _workBook.SaveAs(excelPhysicalFilePath,Excel.XlFil eFormat.xlWorkbookNormal,null,null,false,false,Exc el.XlSaveAsAccessMode.xlExclusive,false,false,null ,null,null) ; it always returns error "System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC" however, I also has an windows form test app which runs exact same code, but it works. So i wonder maybe the error is related to some new restriction implemented for service/DCOM in windows server 2008, can somebody give me some idea how to solve it? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can not save spreadsheet from a windows service on windows ser
It's not permission, my service is run under local system and the folder has
been given full control to everyone...... I believe it has something to do with the way windows server 2008 handles service/DCOM call, because that's the only difference between the test app and service. and excelPhysicalFilePath is pointing to local drive. "Alan Moseley" wrote: Is it permissions? Your service will either be running under the Local System account, or you will have specified it to use another account. If it is running under Local System then try assigning another username to it (in the Services applet in Administrative Tools). Alternatively, is excelPhysicalFilePath pointing at a mapped drive? Mapped drived do not exist from a service's perspective. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "dragonemp" wrote: I have a service app that create excel spreadsheet automatically. this worked on xp and windows server 2003. but now i need it work on windows server 2008. When the service run to this line: _workBook.SaveAs(excelPhysicalFilePath,Excel.XlFil eFormat.xlWorkbookNormal,null,null,false,false,Exc el.XlSaveAsAccessMode.xlExclusive,false,false,null ,null,null) ; it always returns error "System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC" however, I also has an windows form test app which runs exact same code, but it works. So i wonder maybe the error is related to some new restriction implemented for service/DCOM in windows server 2008, can somebody give me some idea how to solve it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Installing service reminder popup windows in excel | Excel Worksheet Functions | |||
Last Saved by Field not populating with Windows XP Service Pack 2 | Excel Discussion (Misc queries) | |||
Creating Windows Message Service Alert | Excel Programming | |||
what service pack do I have with my windows 2000? | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) |