VBA \ Shared ressources \ Error Executing Object required (Error 424) RRS feed

  • Question

  • Hello,

    i have a problem using VBA script within MS Project 2013 and a .mpp file which use share resources.

    Here is the code which work fine when the .mpp do not use shared resources. But when the .mpp use share resources, there is an error 424 (Object required (Error 424)) at the line "SetactivePjt=Application.ActiveProject". When the projet open, there is a windows asking me if i want to open the shared resources file. I ask me if this windows do not stop the execution of VBA script and is the source of the error...

    How make this VBA script run fine even when the .mpp file is using shared resources ?


    Option Explicit Dim activePjt As Project Dim X As New EventClassModule Sub auto_Open() Set activePjt = Application.ActiveProject Set X.Project = activePjt activePjt.Activate End Sub

    Public WithEvents Project As Project Private Sub Project_Calculate(ByVal pj As Project) PercentWorkCompleteToPhysicalPercentComplete End Sub

    Tuesday, March 29, 2016 3:59 PM


All replies