none
VBA - Execution Error 1101 RRS feed

  • Question

  • Hello,

    I have a VB script who is sometimes having an execution error 1101 on some tasks on the following line of code :

    Set objNewEngagement = ActiveProject.Engagements.Add(intEngResourceID, curAssignment.Start, curAssignment.Finish, curAssignment.Work)

    The error is the following when running from the VBA editor :

    And if I am running the macro from the "Display macros" window in the developer tab I have another error (also blocking on the same line of code) :

    Does somebody has an idea of what I am doing wrong ? This line of code is running on every assignment of every tasks in the projects and the error is only appearing on some projects and only on specific tasks but I don't know why...

    Thank you in advance for your help.

    zigune

    Friday, October 25, 2019 8:56 PM

All replies

  • Hello,

    I found someting but it does not explain why the error is happening... On the task that is blocking the script, if I change the duration unit from "Elapsed days" to "days" it's working... I assume there is a problem with the enterprise holidays when it's in "Elapsed days" but does anyone has an idea of why the behaviour is this one ?

    Best regards.

    zigune

    Monday, October 28, 2019 9:51 AM