Microsoft Office® Project (MSP) throws a target "Out of Range", "Subscript out of range" or "OpenFromDatabase" error.
The errors that are thrown may include the following:
Target: Microsoft.Vbe.Interop.VBProject Item(System.Object)
Error: Subscript out of range
Trace: at Microsoft.Vbe.Interop._VBProjects.Item(Object index)
at CAClarityAddIn.ClarityUI.ClarityUI_Load(Object sender, RibbonUIEEventsArgs e)
Error: The macro "OpenFromDatabase" cannot be found.
Steps to Reproduce:
Alternatively, the error may also occur when MSP is opened from the user's desktop and the Open icon on the CA PPM Integration button is selected. When this is the case, opening Microsoft Project from Clarity by clicking on the "Open in Scheduler" drop down will throw a different error such as "An error occurred while opening CA PPM in Microsoft Project. Please try again."
This is typically due to a corruption of the Global.MPT file
Delete or rename the Global.MPT file on the user workstation and generate a new Global.MPT using the steps below:
Important: DO NOT DELETE the global.mpt file that MSP creates in the following folder:
C:\Program Files\Microsoft Office\OFFICE11\1033
For other possible reasons for the "An error occurred while opening CA PPM in Microsoft Project. Please try again." error, see:
KB Clean Uninstall of the MSP Interface
See MSP Integration - Master KB of Known Issues
See MSP Integration Known Defects - Master KB
Tips on searching for known Clarity Issues using Self Service