28 | | 1. MS-Excel Ticket editor |
29 | | 2. MS-Project connector. |
| 28 | === MS-Excel Ticket editor === |
| 29 | 1. fill setting sheet |
| 30 | || [[Image(VBAExcel01.png, link=)]] || |
| 31 | |
| 32 | 2. Create sheets that are same name as project names |
| 33 | || [[Image(VBAExcel02.png, link=)]] || |
| 34 | |
| 35 | 3. Push "Import tickets" button |
| 36 | || [[Image(VBAExcel03.png, link=)]] || |
| 37 | |
| 38 | 4. Edit imported tickets' fields |
| 39 | || [[Image(VBAExcel04.png, link=)]] || |
| 40 | |
| 41 | 5. Add new tickets |
| 42 | || [[Image(VBAExcel05.png, link=)]] || |
| 43 | |
| 44 | 6. Push "Check modified fields" button |
| 45 | |
| 46 | 7. Confirm the edited fields' background color are changed. |
| 47 | || [[Image(VBAExcel07.png, link=)]] || |
| 48 | |
| 49 | 8. Push "Update" button |
| 50 | |
| 51 | 9. According to the WEB browser, modified tickets' fields are changed |
| 52 | || [[Image(VBAExcel09.png, link=)]] || |
| 53 | |
| 54 | |
| 55 | === MS-Project connector === |