Automation error when running phstat in excel 2016 pdf#

right-click->convert to Acrobat PDF - will no longer work). Excel will return the cumulative probability of the event x or less happening. Incidentally, this issue also causes Adobe Acrobat 9 to fail (Explorer integration - i.e. As soon as I did this, my macro started working again. Since I only have ExcelДў007 installed, then all references should be to Version 12.0.0.0 (2007) - I deleted the entire registry key for any entries that had references to Version 14.0.0.0 (2010), which is not installed. To fix it in Excel, what I did was do a search through the registry for registry data containing '' (since registry key in the above post relates to Outlook throwing the error rather than Excel). The fix for the issue is hinted at here, for the same issue with Outlook: Reinstalling Office 2007 does not fix it - perhaps uninstalling Office 2010 completely would, but it might not (and that's not a possibility for me). I still have OneNote 2010 installed (but that's the only thing from Office 2010) - and probably because of this every now and againД«its of Office 2010 reappear in the registry and corrupt the Office 2007 install.

In my case, I have Office 2007 installed, then upgraded to 2010, then uninstalled 2010 and re-installed Office 2007.

It is caused by having references to multiple versions of Excel in the registry, and automation defaulting to one that is no longer installed. GoTo EarlyExit If the userform fields are completed and a worksheet with the same name exists, set boolean to true Else On Error Resume Next Dim tmpWS As Worksheet This will error if sheet doesnt exist Set tmpWS wb.Worksheets(TestCaseNameBox. In the Add-Ins available box, select the check box for the Add-in you want to activate or deactivate, and then click OK. I had this same problem (but with Excel 2007), and have now fixed it. Excel Details: Details: Alert: Excel cant open two workbooks with the same name at the same time restart your excel and then enabling it again - On the Tools menu, select Add-ins.