Question about VB.net to access
I currently have a VB.Net program that connects to a excel workbook.
Works great locally but when I run a time triggered scheduled job through report manager on the server; I get an error. The error is:
ComException (0x800A03EC) "FilePath\File" Could not open excel or File path not found.
I also get a similar issue with Win automation and a triggered task.
I understand that this is a common exception for running the
Interop.Excel. I believe this has something to do with the security permissions that the program receives in running under a scheduled tasks instead of an actual user id.
My questions are:
1. Can this error be fixed? I have not found any research that
supports this. If so, How?
Thank you in advance for your comments. I apologized if this is the wrong forum for this question, I didn't know where else to put this topic.