How do I run Excel 2016 from a Service Account, on a Server.
I have written an automation in Python that calls a VBA script in an Excel Sheet. Everything works fine until I try to execute them on a server. When I am logged into the server everything works fine also. But, as soon as I am logged out of the server the excel sheet stops running. I get the following error:
"(-2147467238, 'The server process could not be started because the configured identity is incorrect. Check the username and password.', None, None)"
- I have searched for this error and the web says I have a corrupt file somewhere. (I don't, I have run the scan and fix and it found nothing.
- I have tried different modules in Python it did not work.
- I have tried using PowerShell to call the VBA script. Again, it works fine with my Account but not when it is run under the service account when I am not logged in.
- At first I had some problems running it under the Service Account, but we read up on it and there were a few tweaks we needed to make to the Com objects etc.. and go it to work. ( Well work when I am logged in.)
- I have tried running it from a batch file, from the command line and from Python. No dice.
I understand this is not supported by MS, but my Boss insists that it can be done. If my Boss says it can be done, then I am obliged to make it happen. ( I am sure I am not alone in this.) Does anyone have any clue on how to do this.
Thanks,
-matt