Forum Discussion
PowerShell Direct - Unable to open Excel workbook with Excel.Application ComObject
I hate to be the one to answer my own question, but that is what's happening.
After what I thought was a thorough three day search, I happened across a similar solution used for another like situation.
I found that going into DCOM Config and, in the properties of the Microsoft Excel > Identity tab, change the setting to "The interactive user".
Since this is not a production machine and is being used for testing, I have not looked any deeper than solving my immediate problem. To those who see a security issue, again, this was not a consideration for me in this case. If it was production, I would spend more time considering the collateral of this change.
I hate to be the one to answer my own question, but that is what's happening.
After what I thought was a thorough three day search, I happened across a similar solution used for another like situation.
I found that going into DCOM Config and, in the properties of the Microsoft Excel > Identity tab, change the setting to "The interactive user".
Since this is not a production machine and is being used for testing, I have not looked any deeper than solving my immediate problem. To those who see a security issue, again, this was not a consideration for me in this case. If it was production, I would spend more time considering the collateral of this change.
Thanks Tom for this. I created an account in the Tech Microsoft Community just to send my gratitude for sharing your findings. I have the same issue and updating the DCOM config worked for me.