Consulting

Results 1 to 4 of 4

Thread: Crashing project activity duration VBA macro

  1. #1
    VBAX Newbie
    Joined
    Mar 2022
    Posts
    5
    Location

    Question Crashing project activity duration VBA macro

    Hello and thanks for your help in advance.

    I am working on time-cost optimization for a project and would like to automate process of creating baseline with actual project duration and then reduce activity duration to minimum. For each activity there are 5 alternative durations with associated costs for each mode of activit execution. So I would need a VBA program to set activity duration to maximal value of these five alternatives (Duration1, Duration2, Duration3, Duration4 and Duration5) and then save this scenario as a project baseline. Afterwards it should set activity duration as minimal value of activity duration from five alternatives. I am attaching example file, so if anyone has any idea i would be gratefull. The file can be downloaded from https://www.dropbox.com/s/ja0kgb9o8u...ample.mpp?dl=0 (forum does not allow me to upload this attachment for some reason).

    Thank you in advance and have a graeat day.
    bdasovic

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,217
    Location
    What type and size are your files?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    Quote Originally Posted by Aussiebear View Post
    What type and size are your files?
    most likely Microsoft Project Pro.

  4. #4
    VBAX Newbie
    Joined
    Mar 2022
    Posts
    5
    Location
    The file is .mpp and I have been using MS Project Professional 2019, and the file is around 350 KB. I have tried uploading file only as well as zipped, but it didn't work.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •