Answer Question
Please Help! My windows service has permissions problems running a macro in an Excel spreadsheet.
I have a macro in an Excel spreadsheet that connects to an OPC server to retrieve data. I works just fine when I run it manually, or when I run it programmatically from a standard windows program. But when I try to do it from a service (running the same code as the standard windows program), it fails.
If I run the service from the Local System account, it opens the spreadsheet but completely loses track of the Excel object and cannot close it. If I then check "Allow service to interact with Desktop", it opens the spreadsheet and runs the macro, but the macro then doesn't have permission to access the OPC server. If I run the service from the Administrator account, the service does nothing - no event log entries or anything. Can someone PLEASE help me quickly with this?
TEXT
Uploading file and scanning for virus...
Please Wait