we are pulling data in to Excel, using OLDB connection's. however microsoft excel doesnt have activation key, when ever we open the excel, we are getting popup window alerting about activation, we simple close that window, and then manually clicking the button Refreshall in data tab. Yet we plan to automate this refreshall work using powershell script. script is unable to suppress this popup window. Please suggest me the solution.
i Have tried below code...
Exception calling "RefreshAll" with "0" argument(s): "Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED))" At line:5 char:1 + $WB.RefreshAll() + ~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : ComMethodCOMException
User contributions licensed under CC BY-SA 3.0