= This VBA class module is MS-Office connector via XML-RPC. = == Description == There are following samples. 1. MS-Excel Ticket editor 2. MS-Project connector. == Bugs/Feature Requests == Existing bugs and feature requests for VisualBasicTracConnectorIntegration are [report:9?COMPONENT=VisualBasicTracConnectorIntegration here]. If you have any issues, create a [http://trac-hacks.org/newticket?component=VisualBasicTracConnectorIntegration&owner=okazaki new ticket]. == Download == Download the zipped source from [download:visualbasictracconnectorintegration here]. == Source == You can check out VisualBasicTracConnectorIntegration from [http://trac-hacks.org/svn/visualbasictracconnectorintegration here] using Subversion, or [source:visualbasictracconnectorintegration browse the source] with Trac. == Example == === MS-Excel Ticket editor === 1. fill setting sheet || [[Image(VBAExcel01.png, link=)]] || 2. Create sheets that are same name as project names || [[Image(VBAExcel02.png, link=)]] || 3. Push "Import tickets" button || [[Image(VBAExcel03.png, link=)]] || 4. Edit imported tickets' fields || [[Image(VBAExcel04.png, link=)]] || 5. Add new tickets || [[Image(VBAExcel05.png, link=)]] || 6. Push "Check modified fields" button 7. Confirm the edited fields' background color are changed. || [[Image(VBAExcel07.png, link=)]] || 8. Push "Update" button 9. According to the WEB browser, modified tickets' fields are changed || [[Image(VBAExcel09.png, link=)]] || === MS-Project connector === 1. Add custom fields. ||type ||name ||MS-Project's field || || ||custom||due_assign ||Start ||required || ||custom||due_close||Finish ||required|| ||custom||complete||PercentComplete ||required|| ||custom||blocking||(dependency) ||add blicking ticket|| ||standard||summary ||name || || ||standard||owner ||resource || || ||standard||milestone ||(dependency) ||Add preceding task for the milestone|| ||standard||version ||(dependency) ||Add preceding task for the mversion|| ||custom||summary_ticket||(summary task) ||Optional, for TracDependencyPlugin || ||custom||depencencies||(dependency) ||Optional, for TracDependencyPlugin || ||custom||baseline_start||BaselineStart ||Optional || ||custom||baseline_finish||BaselineFinish ||Optional|| 2. create tickets. 3. Open TracProject.mpp 4. Create blank mpp file. 5. Active created mpp file. 6. Push "Import" button || [[Image(VBAPrj01.png, link=)]] || 7. input settings for your environment, then push "Validation" button || [[Image(VBAPrj02.png, link=)]] || 8. If connection is valid, then enable "Import" button. Push this button || [[Image(VBAPrj03.png, link=)]] || || [[Image(VBAPrj04.png, link=)]] || == Recent Changes == [[ChangeLog(visualbasictracconnectorintegration, 3)]] == Author/Contributors == '''Author:''' [wiki:okazaki] [[BR]] '''Contributors:'''