Sedang Disiapkan

Write a MS Project VBA Macro to Create a Summary Schedule

Overview

The task is to create a Microsoft Project Macro that will automatically create separate summary schedule from details contained within the base schedule. A numbers column is used in the base schedule to indicate the tasks and summary tasks that need to appear in the summary schedule. A text column is used in the base schedule to indicate the predecessor and successor linking that needs to appear in the base schedule.

Creating the Summary Schedule

• The summary schedule shall be created in a separate instance of Microsoft Project (i.e. not within the same project).

• The project standard calendar for the summary schedule shall be the same as the base schedule

• The summary schedule calendar options for Hours per day, Hours per week and Days per month calculations shall be the same as the base schedule

• All tasks in the summary schedule shall be auto scheduled.

• Column Number1 in the base schedule contains either a 0,1 or 2 against each task. 0 represents that the tasks is not to be included in the summary schedule. 1 represents that it is a summary task (or level 1) in the summary schedule. 2 represents that it is a normal task (level 2) in the summary schedule.

• Summary schedule level 1 task names shall be a dynamic link to the corresponding task name in the base schedule.

• Summary schedule level 2 task names, start dates, finish dates and % complete shall be a dynamic link to that of the corresponding task in the base schedule.

Predecessor Links

• The summary schedule predecessor links for each task shall be captured in the Text26 column of the base schedule.

• The predecessor text in the base schedule will indicated the base schedule task ID.

• A comma will separate multiple predecessors

Formatting

• The gantt chart bar for each group of level 2 tasks in the summary schedule shall be coloured a different colour.

• The order of colouring for each group shall be:

1. 4626167

2. 13020235

3. 10642560

4. 5880731

5. 5066944

6. 12419407

7. 8210719

8. 5474707

9. 16738047

10. 6750156

• If there are more than 10 groups of tasks in the summary schedule the colouring shall start again from the top.

Saving

• Once created the summary schedule shall be saved.

• The summary schedule file path shall be the same as the base schedule.

• The summary schedule file name shall be the same as the base schedule with the addition of the word “Summary” and the date. The format shall be: base schedule file name & “- Summary – yyyymmdd”

Rights

• I shall be able to view, update and change the macro once it has be submitted

• All rights to the code shall belong to me

Kemahiran: Microsoft, Penjadualan Projek, Visual Basic

Lihat lebih lanjut: project vba auto scheduled, create macro, word create schedule macro, vba create schedule, create macro project, create summary task project macro, project vba hours per day, project vba create calendar, vba project auto schedule, write names, vba with, create a chart, create a bar chart, week schedule, vba for word, vba for, vba day of week, microsoft vba, microsoft macro, me vba, macro microsoft word, create macro in word, gantt project, write a summary, vba word

Tentang Majikan:
( 1 ulasan ) Scarborough, Australia

ID Projek: #1582078

Dianugerahkan kepada:

Kryptora

Hello, I see you require an Project macro which can automatically create separate summary schedule from details contained within the base schedule. I understand you will have the rights to the macro code. I have sent y Lagi

$250 USD dalam 7 hari
(34 Ulasan)
5.4

5 pekerja bebas membida secara purata $260 untuk pekerjaan ini

bharanisrihari

Hello, VBA expert here. Please check PM for details. Thanks!

$250 USD dalam 10 hari
(27 Ulasan)
5.6
ashmantri

I do have sound expertise on writing macro programs. Pleas echeck PMB, thanks, Ashish M

$350 USD dalam 15 hari
(4 Ulasan)
2.5
ismarodri123

Experienced VBA programmer, more than 10 years making macros for Excel and Word.

$150 USD dalam 5 hari
(0 Ulasan)
0.0
webspaceit

As per your requirement...we are very much interested for your project. We can complete your project quickly and efficiently in time. Details will be discussed in the message.

$200 USD dalam 10 hari
(0 Ulasan)
0.0
chirag01

I am working on VBA/VSTO project. Good experience on Excel VBA.

$250 USD dalam 15 hari
(0 Ulasan)
0.0