I would like to automate a task using DDE based on COM. I'll be using Powershell to gather system data then consolidate the data in Excel. I'm always having an error of "error 0x80010001 (RPC_E_CALL_REJECTED)". How do I consolidate dde powershell with excel? I'm using Microsoft office 2010 and Windows 7.
Â
How do I consolidate Dde powershell with Excel?
Â
Hello Wallace,
The error you are getting generally occurs because of several reasons. Hence, we shall need some more info regarding your problem. Nevertheless I am giving you the most common solutions to your problem here:
Â
-
Do you have the Norton Antivirus plugin installed in your computer? Microsoft and Norton do not go well with each other. Hence, if you do please try disabling the plugin and see if the problem persists.
-
Please check for the HKEY_LOCAL_MACHINESOFTWAREMicrosoftOLE register in the regedit.(Start-> Run->Â Regedit). Set it to Y and reboot your PC. Check to see if the problem still exists.
-
Such problem may also occur because of a deadlock in the excess process where two threads block each other and wait for the resources.
In any case please reply us after trying the above tricks. We shall dig deeper if the problem still persists.
