How do I consolidate Dde powershell with Excel?

Asked By Wallace Brownings 10 points N/A Posted on - 02/08/2013

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.

 

• Status: Open
• Question Views: 1333
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Noell Pearson 0 points N/A #164535

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.

About Noell Pearson

Questions
3

Answers
101

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 02/28/2013
• Question Category: MS Excel